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).
Question I have ~5 people editing different fields of a record on different computers on a Data Access page. Will that work, or is it best to break up the information into a separate table for each user.
Answer Hi
5 users on the same record will cause you problems in Access. You'll have too implement a locking strategy to look after this.
If the users are all editing the same record, why would breaking out the data into different tables help?
I'm a little confused as to why yoiu said this - maybe you don't mean 5 users on the same record.
The very leadst you must do is spli your database into File Server. Please see my article...
