Multi-User Database Access

[DBFIN]

I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??

 

[bob fitz]

Have you split the db. This is a "Must Do" for multiple users

 

[deljr15]

What is the error message you get when you try to open the database as a second user?

I have seen this happen if user 1 is in exclusive access, or if user 1 is/has edited anything sense last close.

 

[DBFIN]

I am not familiar with how to split database. Can you advise ?

 

[GinaWhipp]

Here you go...

http://www.kallal.ca/Articles/split/index.htm
http://allenbrowne.com/ser-01.html

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

If each user needs Access you can install the Runtime…
Access 2007
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en
Access 2010
http://www.microsoft.com/downloads/...cd-5250-4df6-bfd1-6ced700a6715&displaylang=en
Access 2013
http://www.microsoft.com/en-us/download/details.aspx?id=39358

 

[bob fitz]

There is a wizard to do the splitting. It will create one Back end db and one Front end db.
The Back end is used to hold the tables only. Everything else (Forms, Queries, Reports etc) is in the front end. Each user should be given a copy of the front end. Each front end should then be linked to the tables in the back end.

 

[bob fitz]

Thanks Gina. I was just about to search for a few links on the subject

 

[GinaWhipp]

No problem, just passing by...