Keep them in one table.
What you should have is one table which holds user information which you can
use to log people in. Then create other tables to store relevant info on
them. For example. I have a table which store username, password, +
general details of user. I then have a table called education and a table
called work. These tables hold all of the users educational history and
work experiences reapectively and can ghold many records for each user.
If you have a table per user your database would feasible have
hundreds/thousands of tables with only one record in each!
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 06 November 2000 14:54
To: CF-Talk
Subject: Database Question???
I am setting up a website in which people are creating records and storing
them in a database (Access 2000 at this time). Am I better off with a
single table that includes all of the records of all users or should I set
up a seperate table for each user? I am pretty sure that the seperate
tables would have better performance but will probably be harder to upgrade
to SQL 7 later. Please let me know your opinions.
Thanks,
Rich
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
