Clearing Error 3045

[DaveSlade72]

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?

I've just taken my happily working duplicate of the database from the folder that the locked version is in, copied it to a different folder, renamed it and over-written the locked database. The new version of the database is now locked.

I cannot create a backup using the windows backup facility bacause it's apparently in use by another process!


Backup Status
Operation: Backup
Active backup destination: File
Media name: "Backup.bkf created 17/01/2007 at 13:34"

Backup of "S: \\Sewbrecserver \SEWBReC"
Backup set #1 on media #1
Backup description: "Set created 17/01/2007 at 13:34"
Media name: "Backup.bkf created 17/01/2007 at 13:34"

Backup Type: Normal

Backup started on 17/01/2007 at 13:35.
Warning: Unable to open "S:\M. MapMate files\SEWBReC(M M).mdb" - skipped.
Reason: The process cannot access the file because it is being used by another process.


Backup completed on 17/01/2007 at 13:35.
Directories: 2
Files: 0
Bytes: 296
Time: 1 second

[NeoPa]

I think Backup in this case simply means a file copy.
This is similar to ideas referred to in post #6.

[DaveSlade72]

I think Backup in this case simply means a file copy.
This is similar to ideas referred to in post #6.

Sorry, I mis-understood. Still, it was worth a try!

Assuming that the database really does have an active process running somewhere (either on the workstation or the server), is there any way of finding out what that process might be so that I can simply stop it?
Obvioulsy, I could simply restart the server, but I don't want to disrupt the other two members of staff as we've got a lot on at the moment.

[NeoPa]

My response in post #8 was designed to do just that. Unfortunately, the results you got surprise me and I'm unable to interpret them into anything that makes sense. That would be the tool for that task though :confused:

[DaveSlade72]

My response in post #8 was designed to do just that. Unfortunately, the results you got surprise me and I'm unable to interpret them into anything that makes sense. That would be the tool for that task though :confused:

Well thanks very much for trying. When I get the chance to re-boot the server I'll let you know if the problem goes away!

[DaveSlade72]

Well thanks very much for trying. When I get the chance to re-boot the server I'll let you know if the problem goes away!

Re-booted the server this morning before the others got into the office, and the problem has gone away. All very mysterious!

[NeoPa]

A problem gone is a problem ... well ... gone I suppose :)