multiple users (editors) in mdb file?

[UEI]

Hi -

Can I set up an mdb file where multiple users can edit different tables at the same time?

thanks.....

 

[boblarson]

Edit Data - YES.

Edit Structure - NO.

For data entry/editing you would normally have a split database where you have a Backend (with tables only) sitting on a file server where everyone has read/write/delete rights and then you have a frontend which is linked to the backend and then a COPY of the frontend is distributed to each user to put on their computer.

Then you keep a master copy to do development work in and then redistribute when you release a version. You can use an AutoUpdater to keep the users having the latest copy, and there is a free Auto Updatae Enabling Tool on my website you can use, if you so desire. There are others out there as well, including Tony Toews (pronounced TayVZ) who has one.

 

[UEI]

Hi -

Thanks for your response. That does seem to be the best way to handle the situation.....thanks for your help!

 

[gemma-the-husky]

out of interest, you should not need to redesign tables in general use, and you should not enter data directly into tables.

otherwise, access databases are multi-user out of the box.