Back End database only allowing one user

  • Thread starter Thread starter Trent
  • Start date Start date
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!
 
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
 
Back
Top