Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

Can multiple users use an Access database at the same time?

Contents
  1. How many users can use an Access database at the same time?
  2. Can multiple users edit Access database?
Share a single database In this method, the database file is stored on a shared network drive, and all users share the database file simultaneously. Some limitations include reliability and availability if there are multiple simultaneous users changing data since all database objects are shared.


How many users can use an Access database at the same time?

At Least 200 Simultaneous Microsoft Access Users on an Access/Jet Database. If everyone is just viewing data or entering data into a table, that takes very little work and a large number of people (well over 200) can be supported.

Can multiple users edit Access database?

The "over all" settings you are playing with don't change anything here (well except the option to open databases as shared - but that's already the default and already a given since more then one user is able to edit the data. So change the form in question locking setting to "edited" record.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours