Clearing Error 3045

[DaveSlade72]

I cannot compact or repair an Access 97 database due to Error 3045 - File in use.
If I close the database, there is no ldb file left open, so the database should not be locked, and there are no other users logged into the database which resides on our server.
I can copy the database to another folder, compact it and copy it back with no problems, but the server version is still apparently locked. Where is this file lock infrormation held if it is not in an ldb file? Can I re-set this setting in any other way?

I'd apreciate any thoughts on this.

Dave Slade
Cardiff

[MMcCarthy]

I cannot compact or repair an Access 97 database due to Error 3045 - File in use.
If I close the database, there is no ldb file left open, so the database should not be locked, and there are no other users logged into the database which resides on our server.
I can copy the database to another folder, compact it and copy it back with no problems, but the server version is still apparently locked. Where is this file lock infrormation held if it is not in an ldb file? Can I re-set this setting in any other way?

I'd apreciate any thoughts on this.

Dave Slade
Cardiff

When the database is open does the ldb file appear where you expect it to be?

[DaveSlade72]

When the database is open does the ldb file appear where you expect it to be?

Yes it does.

[MMcCarthy]

Yes it does.

When you compact and repair even if the file is locked by another user the database copies itself first and then overwrites itself so it should be creating a copy of itself in the folder even if the file is locked so I don't think this is your problem.

You say you copy the file and compact and repair it no problem. Are you doing this in the same folder. What I am wondering is if the problem is more one of write privilages in the folder than the database itself.

The only other option I can think of is that there is corruption but this doesn't make sense if you can copy it and its fine.

Mary

[NeoPa]

Try speaking to your Network people.
There may be special permissions on the folder as MMcCarthy says.
I could go through all sorts of technical ways of finding the problem (which you may well not follow) but the more sensible course is to ask them to assist you with determining and then, if necessary, fixing the problem.

[DaveSlade72]

Try speaking to your Network people.
There may be special permissions on the folder as MMcCarthy says.
I could go through all sorts of technical ways of finding the problem (which you may well not follow) but the more sensible course is to ask them to assist you with determining and then, if necessary, fixing the problem.

The problem is, I am our Network people! We are a very small not-for-profit organisation and I deal with all the IT issues, including the server management etc. Hence I tend to rely alot on forums such as this to solve problems that I have no experience of. There are only four of us in the office, and none of the others have any reason to go near this database, or interact with the server directly.

The problem has only recently arisen, and I think it is related to an attempt at automating an update process. I've just successfully compacted a re-named version of the database in the same folder as the original. I had thought maybe I could simply delete it and use the renamed version instead... but of course I can't because it thinks its in use by another user!

[NeoPa]

Right then. That makes sense.
Are your MDB files stored on a separate PC or are they on your workstation?

1. Go to your server machine.
2. If not possible then do NOT skip over steps #5-6
3. Open Computer Management (Use Admin Tools or %SystemRoot%\sy stem32\compmgmt .msc /s)
4. Go to step #7
5. Select Action / Connect to another computer.
6. Select your server PC from the list and enter
7. Select System Tools / Shared Folders / Open Files.
8. Look through this list for the information as to who has access to the file(s)
9. Force close of the file(s) if (ONLY IF) appropriate.

[DaveSlade72]

Right then. That makes sense.
Are your MDB files stored on a separate PC or are they on your workstation?

1. Go to your server machine.
2. If not possible then do NOT skip over steps #5-6
3. Open Computer Management (Use Admin Tools or %SystemRoot%\sy stem32\compmgmt .msc /s)
4. Go to step #7
5. Select Action / Connect to another computer.
6. Select your server PC from the list and enter
7. Select System Tools / Shared Folders / Open Files.
8. Look through this list for the information as to who has access to the file(s)
9. Force close of the file(s) if (ONLY IF) appropriate.

The file is on the server, and as far as the server is concerned the file is not open. When I open the file on the workstation the mdb & ldb files appear in the open files list, but when it's closed they disappear again.

[NeoPa]

Can you try to make a copy of your MDB file into the same folder with a different name and let me know what happens.

[DaveSlade72]

Can you try to make a copy of your MDB file into the same folder with a different name and let me know what happens.

I can create a copy in the same folder, and I have no problem doing anything with that copy. This is what makes the situation all the more irritating, since I could simply replace the one that doesn't work with one that does... but I can't delete or rename the one that thinks it's locked!

[DaveSlade72]

I can create a copy in the same folder, and I have no problem doing anything with that copy. This is what makes the situation all the more irritating, since I could simply replace the one that doesn't work with one that does... but I can't delete or rename the one that thinks it's locked!

I've just looked at the processes currently running on the Server, and there is an NMSAccess.exe process running whilst as far as I can see there are no open databases. Can I simply stop this process do you think?

[NeoPa]

(How to remove NMSAccess error) should tell you more about it.

[DaveSlade72]

(How to remove NMSAccess error) should tell you more about it.

Thanks - looks like it's got nothing to do with Access, so probably not related to my file - locking problem.

[NeoPa]

I'm afraid I can't think why this is happening Dave.
Everything you say seems logical. You've already tried any other ideas I've had :(
Sorry.

[MMcCarthy]

Thanks - looks like it's got nothing to do with Access, so probably not related to my file - locking problem.

Dave can you copy out a backup of the file and compact and repair it. Then delete the existing file and replace with the backup. Does this make any difference?