Back End database only allowing one user

T

Trent

I have a Access 2002 database (split into a table-only
back end and application-type front end with linked
tables, both .mdb files) that has been working in a multi-
user environment on a network (but the back end residing
only on a client PC). This has just been installed on a
new network managed by Server 2003, with the back end
held on the Server drive but now only one client user
(using the Access Runtime) can open the back-end at a
time. The file seems to be locking. I have checked user
security previleges on the server and the record locking
facilities on Access and can find no reason. Help!
 
A

Arvin Meyer

Check permissions again. Server 2003 locks them down very tightly. You need
to have all permissions except "Full Control" on the server. For instance,
you need to have file create and delete permissions so that you can deal
with the LDB file.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split Database 9
looking for a way to unlock a back end mdb file 16
SQL Server Backend: linked tables or no more bound forms ? 4
Access front end to Oracle table user load 3
Storing Back End on a Terminal Server 4
problems creating a muti-user database 1
UNC path network performance 1
On Sharing Unsplit Databases 10

Top