Access DB deployment on shared drive

[DevAccess]

Hello

I have deployed the access db on shared drive, having all five users shortcut on their desktop, but when users modify/add/delete the data it is not visible to other users.


Please note that they are not doing these actions at a time.

Please let me know what is missing what should I have done before deploying to shared drive any precautions. ?

Thanks

 

[bob fitz]

Have you split the db.
You should have the backend file on the shared drive with each user having their own copy of the front end on their own machine. Each front end copy would be linked to the tables in the back end

 

[The_Doc_Man]

Search this forum for the topic "SPLITTING" - articles abound on this subject.

 

[jdraw]

see some FMS articles for more info
http://www.fmsinc.com/MicrosoftAccess/DatabaseSplitter/
http://www.fmsinc.com/microsoftaccess/performance/linkeddatabase.html
http://www.fmsinc.com/tpapers/faster/

Good luck.