Question Database State -- Error 3734

FERUSH

New member
Local time
Yesterday, 19:32
Joined
Feb 15, 2013
Messages
6
Using Access 2010 to edit/dev a 2003 Access DB file (.mdb) I have had not problems until I was writing to a sequential output file (new code), during which time the computer screens fadded/fogged. I shut the computer down. Upon restarting, the Access DB file and .ldb are in a state of "being used." Attempts to open the DB result in the error message:

The database has been placed in a state by user 'Admin' on machine '<..>' that prevents it from being opened or locked.

The .ldb file can be opened only in read access.
My problem is not in getting the Error 3734 while running, it is getting the whole DB file/application open. Help? Help?
Can the .ldb file be whacked (even though shows being used)? Would that help or make matters worse? Since these are .mdb and .ldb files, maybe this is better answered as an Access v2003 issue.
 
Last edited:
Can you delete the ldb file?

Or copy the DB to a Temp folder.

You should be able to open it then.

Please let me know.
 
Can not delete the ldb file.
Copying the .mdb file to a different directory was an instant solution. Many Thanks!
 
Sorry, but now the small problem of how do I delete/eliminate to "open" .mdb and .ldb files? Somehow I need to fool the computer or reset the file status. Not really and Access problem.
 
Not sure I understand your last post.

You may need to do a Decompile your Database. I feel that there may be some code gone wrong.
 
Searching for an answer to deleting an OPEN file, I found:
[I supply it here only to supply a complete resolution of my whole problem for a future user.]
I would suggest you to check in safe mode and try to delete the file and check.
Boot the computer in Safe mode and check if the issue persists. Follow these steps to start the computer in safe mode.
a) Press the ‘Windows + C’ key on the keyboard.
b) Click on settings, more pc settings and then general.
c) Scroll down to advanced startup, click restart now.
d) Click on troubleshoot, advanced options, Windows Startup Settings.
e) Click restart, select safe mode and then press enter.
Note: Restart the computer to start in normal mode.
 
Database was OK after the COPY you (RainLover) suggested. Thanks for the suggestion - seems so simple I'm embarrased. I just couldn't get rid of the old (open) files.
 
Last edited:
The real easy things are not in books. They are simply learnt through experience. Trial and error is also a good learn.
 

Users who are viewing this thread

Back
Top Bottom