You are here:

Using MS Access/MS Access - Multiple Users

Advertisement


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

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


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).

©2012 About.com, a part of The New York Times Company. All rights reserved.