Database access problem

[PaulA]

Hi, all--

I have a reported situation off-site where a workstation is not able to access a A2K database from a network station. Other users on the same network have no problem.

The error message is:

"Could not use <name>; file already in use. (Error 3045) The specified file is currently being used by another user or session. Wait for the other user or session to finish working with the file, and then try the operation again."

The network is Window 2000 and the workstation itself uses Windows 95.

The computer had Office 97 on it and the IT person installed Access 2000 in a seperate folder so the database can be accessed.

Any ideas why we can't access the database from this computer?

Thanks.

 

[RichMorrison]

Paul,

This is a network rights problem.

Each user needs network rights to create and delete, as well as read, modify, etc.

That's because Access tries to create and delete the "LDB" on the network folder.

RichM

 

[PaulA]

Follow-up

Rich,

Thanks for your response.

What do you mean by "LDB"?

Thanks again.

Paul

 

[RichMorrison]

Paul,

An "LDB" is a file created by Access to manage record sharing and locking. There is one LDB for each open MDB, same name with LDB suffix.

Access looks for a matching LDB when you open a database. If it can't find one then it makes one.

If the users don't have create rights then Access will try to open the MDB exclusively. So the first person will open it and all the later attempts produce the error message you see.

Again; the solution is to give the users create and delete rights to the folder on the network drive.

RichM

 

[PaulA]

Rich,

Thanks for your responses--very informative.

We were able to resolve our problem.

Paul