Security 'Could not lock file' (1 Viewer)

B

Boo

Registered User.

Local time

Yesterday, 17:50

Joined

Aug 30, 2004

Messages

32

• Nov 30, 2005

• #1

Hi all,
We are changing domains and are doing alot of bouncing around with passwords and such.
Now all my users who are not in admins can not open our Db.
We get a message 'Could not lock file'. Any ideas?
thanks

 

B

Bat17

Registered User.

Local time

Today, 01:50

Joined

Sep 24, 2004

Messages

1,687

• Dec 1, 2005

• #2

when you open access it creates a *.ldb file in the same directory as the *.mdb.
Users ned to have create permmisions as well as read/write

Peter

 

B

Boo

Registered User.

Local time

Yesterday, 17:50

Joined

Aug 30, 2004

Messages

32

• Dec 1, 2005

• #3

thanks for the idea.

We already have a workgroup with groups and permissions that has been in service for 7 years.
What has happened is we copyed a Db and the workgroup file to another server, tested it, it opened just fine, then deleted the new files on the new server because we were not ready to keep the Db there permanently yet. Now users can't get into the Db via the original files on the server.

 

ghudson

Registered User.

Local time

Yesterday, 20:50

Joined

Jun 8, 2002

Messages

6,195

• Dec 1, 2005

• #4

The users need a custom shortcut that points to the MSAccess.exe file and the workgroup.mdw file and the database.mdb file. That information should be in the target field of the custom shortcut so that the db will be opend with the correct version of Access and the correct workgroup file for the database in question if the problem is security related.