• sqlfriends - Friday, January 20, 2017 2:52 PM

    Sue_H - Wednesday, January 18, 2017 12:28 PM

    Maybe not though. I've seen quite a few places handling this by having a versioning of the access db usually in a table in the access database and keeping the main version on a file share and users having one locally. Whenever the users started up their access db, it checked the version of their local database to the one on the file share and downloaded the updated version if their local copy wasn't up to date. So it was just a matter of updating the one access db on the file share.

    Sue

    How to achieve  and implement :  check version of db and downloaded updated version? 

    Read all about it. http://www.autofeupdater.com/