	AllExperts > Using MS Access
	Search

About Rob Henderson
Expertise
I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions. I also have expierence in application design for all the Office components (Excel, Outlook, etc).

You are here: Experts > Computing/Technology > Business Software > Using MS Access > MS Access - Multiple Users

Using MS Access - MS Access - Multiple Users

Expert: Rob Henderson - 2/8/2005

Question
I am creating a database for 5 different people to input information. Everyone edits the same record in the same table, but can only edit different fields within that record. I am using a data access page for the input. (Each record represents a day, and if that part of production made their deadline or not)

As of now I only have 1 table for all of the data, about (25) fields in total. Would it be better to have 5 tables instead.

Answer
Hi

Please see my aricles on...

http://www.developersforhire.co.uk/resource/tip_files/Multi%20User%20Performance...

and

http://www.developersforhire.co.uk/resource/tip_files/Multiple%20users%20and%20b...

HTH

rob

Add to this Answer Ask a Question