Sharing Databases and Error 3045 1

[JohnInSeattle]

I'm working on a number of Access 97 databases that reside on an NT Server.&nbsp;&nbsp;For some reason other users are unable to open any of these databases if someone else already has the database open.&nbsp;&nbsp;Access pops up the following error msg:<br><br><FONT FACE=monospace><font color=red>Couldn't use &lt;name&gt;; file already in use. (Error 3045)<br>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.<br></font></font><br>With &lt;name&gt; being the name of the database.&nbsp;&nbsp;The databases aren't being opened &quot;exclusive&quot; using the Open Dialogue Box and all have their Default Open Mode set to &quot;Shared&quot; with &quot;no locking&quot; specified.&nbsp;&nbsp;None of the databases have User-Level security.&nbsp;&nbsp;To rule out a VBA based cause I created a new blank database, saved it to the server, and tried to open it on two PCs and got the same error msg during the second open.<br><br>I've worked in other situations with shared databases on NT networks and haven't run into this before.&nbsp;&nbsp;Any light you can shed would be greatly appreciated.<br>Thanks,<br>John

 

[Databaseguy]

I have the same problem. I know that the following are some potential causes:

1. The database resides in a directory where the user accessing the directory doesn't have create or delete rights. When this is the case, Access defaults to Exclusive mode, even thought it wasn't chosen in the Tools/Database/Advanced checkbox or specified using the /Excl command line switch.

2. Someone did set it to exclusive, and the next person to access the database used the file list or their history instead of the using file/open method. Using the file list will open the database in the same state as previously opened.

I've been playing with the *.ldf file. There are a couple of utilities at the Microsoft web site that can help you read this file. I forget the address, but the file is called Jetutils.exe

Also, try going to the server and clearing all of the connections to the database using Server Manager. Sometimes a connection gets &quot;stuck&quot;, I don't know why...

I'm still working on the problem myself. If you find a solution before me, please let me know. I'll do the same for you.

 

[Databaseguy]

Anyone have any suggestions ??? It's driving me nuts...

 

[JoeMiller]

ACC97: &quot;File Already in Use&quot; Error Opening Linked Table on Read-Only Source After SR-2 Update Applied

http://support.microsoft.com/support/kb/articles/Q225/3/51.ASP

ACC2000: &quot;File Already in Use&quot; Error Opening Database on Novell

http://support.microsoft.com/support/kb/articles/Q202/1/71.asp

ACC2002: &quot;File Already in Use&quot; Error Message When You Open a Database That Is Located on a Novell NetWare Server

http://support.microsoft.com/support/kb/articles/Q289/6/81.ASP

Maybe these can help in the right direction? Joe Miller
joe.miller@flotech.net

 

[Databaseguy]

Thanks Joe. I've read all of those articles prior to submitting here, and it seems to be at least a step in the right direction.

However....No one is currently in the file. When I try to delete it, rename it, move it, whatever, I get a sharing violation.

We waited overnight, thinking that the Backup process would clear all of the connections, but to no avail.

Once I get it back, I'm putting in a location where everyone has rights to the folder.....

 

[JohnInSeattle]

Thanks for the replies. I've since solved the problem I was having. This article from the MS support site helped most.

http://support.microsoft.com/support/kb/articles/Q136/1/28.asp

In particular, the section titled &quot;Required Folder Permissions&quot;. Once I got things set-up as laid out in this article my sharing/read-only/etc. problems cleared up.

Thanks Again,
John