multi-user problem

[kenista]

I have read many of the posts here and still can't seem to find an answer to
this problem.

I am using Access 2007, and fter successfully splitting my database and
placing the FE on each local computers hard drive, I am still having problems
getting access to allow mulitple users to use the forms etc in the front end
at the same time.

I get an error message saying that the table in the BE is in use and
unavailable at this time.

Please help.

 

[Daniel Pineault]

1. Open your form in Design View and what is your form's 'Record Locks'
property set to? If it is set to 'All Records' change it to 'Edited Record',
redeploy your front-end to the user and try again.

2. If this is not the problem or does not solve the problem, please post the
exact error number and exact error text.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

I get an error message saying that the table in the BE is in use and
unavailable at this time.

Sounds like a permissions problem. Do the users create privileges so
the LDB locking file can be created?

You can test this by have the users create a txt file in the same
folder as the BE.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[kenista]

Thanks.

I tried the first option and it seems to have fixed my problem.