Access shared tables

Question

Hi all

We are 3 to share Access tables (.accdb) placed on a server

sometimes all is well, but most of the time if we are 2 to work on the same time, it becomes slow.

I know this is not normal but we tried everything and nothing is working

any tips?

Answer 1

You need to set your database up properly for multi-user usage which means you need to split your database and deploy a copy of the Front-End (FE) to each user, amongst other things.  Take a look at:

• http://www.devhut.net/2017/04/09/setting-up-an-ms-access-database/
• http://www.devhut.net/2017/04/20/access-best-practices-and-troubleshooting-steps/

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Dear Daniel

we already did the split of the database (.accdb), the back end with tables on a server PC and each of 3 users has a front end

the setting is done for "sharing" the database

---

Susan Serbey

Answer 3

There'sa lot more covered in those articles.  

Did you persistent  connections at the startup of your database?

Have you optimized your queries to only return the fields you need?

Have you created indexes on the fields you use in WHERE clauses and joins in your queries?

This can also be sure to network saturation, insufficient hardware (the server can't keep up, slow had) ...

It can even be due to improper database design.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net