Expert: Rob Henderson - 2/3/2005

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

http://www.developersforhire.co.uk/resource/dfh_tips_index.htm

|Access|Access General|Splitting an Access Database

HTH

rob