Updating an open database

Question

I have a client with app. 30 users of an Access Db. To apply updates, we have been getting everybody out before we do so.  This is time consuming and difficult to achieve when a lot of staff are using the db.  Is there any way to apply updates to specific forms, queries, reports, etc. without having to first get everybody out ?  They are using Office 365 and the database is .accdb format.

Answer 1

Hi. When you say they're using Office 365, does that mean the data is stored in SharePoint Lists? Otherwise, if your Access database is not "split," then I suggest you do that first. If it was split, then updating the application is just a matter of replacing their copy of the front end with the latest version. And they can do that any time they want to.

You can also use some routine to do it automatically for them. Have a look at the many "Auto FE Updaters" available out there.

Just my 2 cents...

Answer 2

Hi, PeteCV

All multi-user or replicated Access apps should be split, and most single-user apps should be, too. It's good design and also makes the apps more stable, as only the data tables end up being opened by more than one user at a time.

For more information, you could refer to this helpful link:

http://stackoverflow.com/questions/1672077/setting-up-an-ms-access-db-for-multi-user-access

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.