Multi Users Fe/Be read only

[Jake F]

I split a survey database and have the users entering using a mde. It only
allows one person to use it at a time saying that the back end where the
tables are is being used and so the data cannot be saved. Is there something
else I need to do to allow multiple users to access the data?

 

[Golfinray]

Normally, you would have the BE on a lan that everyone has access to. The FE
would be on each user's machine. The users must have read/write/edit/ and
delete rights to the BE file AND the folder it resides in or only one will be
able to use it at a time and then will cause problems.

 

[Jake F]

Okay, so I have the BE and FE which is an mde in the same folder. For
multiple users to be using the file at the same time, it needs to be on each
of their machines so basically they are using different files that send data
to the same BE file. How I have it now with one FE and one BE file in the
same folder, that will only allow one person to use it at a time?

 

[Golfinray]

Yes. If they are both in the same folder, only one user at a time will be
able to use it. A copy of the FE needs to be on each user's computer. That
way, they could have personalized forms or reports if you need them to but
all users have the same access to the tables. If they are all in the same
folder, Access will only let one person at a time have access because two
people might be trying to save work in the same form at the same time. By
putting the FE on each users machine, you eliminate that. All users use the
tables, no problem.

 

[Jake F]

A use had an error saying that the back end file was already in use. This
was before they were given write permissions to the folder, and also the
front end was in the same folder. They now have write permissions, but I'd
like to know if I need to have them create their own copy of the front end as
well or if the problem was probably due to not having write permissions?
Just want to get an idea before I tell them to try again and get the same
error.