Ask a new question

Access database with multiple users

Can multiple users enter data in an Access database at the same time or do they have to enter simultaneously?

Yes, they can but you do need to split it.  For additional information splitting...

http://www.kallal.ca/Articles/split/index.htm
http://allenbrowne.com/ser-01.html
http://www.utteraccess.com/wiki/index.php/Sharing 
 
You may also want to take a look at MVP Tom Wickerath's article…
http://www.accessmvp.com:80/Twickerath/articles/multiuser.htm 
 
To handle the update of multiple front ends see…
http://www.autofeupdater.com/
http://regina-whipp.com/blog/?p=184
http://www.btabdevelopment.com/ts/freetools 

Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

For sure!  As Gina rightfully pointed out, you must first split the database:

Back-End (BE) -> Tables

Front-End (FE) -> Everything else (queries, forms, reports, vba), it is the user interface

Then you need to give a copy of the FE to every user.  They must never share a copy between multiple users.  Below are 2 articles I'd recommend you review so you get a better understanding of the proper setup of an Access database.

--
Daniel Pineault
Microsoft MVP 2010-2021

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Nice articles Daniel going to add those to my list!
Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated September 1, 2023 Views 7,758 Applies to: