Ref: Microsoft Access Application Development

I receive the following error when I try to rename database object:

Error No: 3734; Description: The database has been placed in a state by user 'Admin' on machine 'DISYAD01' that prevents it from being opened or locked.

Admin is me, the machine is mine.

What to do to get around this?

David

Hi David,

That's definitely one of the most annoying error messages Access generates, and I suspect it can be caused by all sorts of things, including a corrupt .mdb file.

I'm assumimg you're the only user in the db, and don't know if this will help you at all, but the only way I've been able to reproduce the error semi-consistently is by trying to open a connection object to the .mdb file I'm currently working in when that .mdb has unsaved changes pending in a code module somewhere. I'm just thinking that renaming an object is bound to be running some DAO code on the projects current connection under the covers, and unsaved changes might be the culprit in that case too. If you happen to have the VBA editor open while trying to rename the object, try closing it first, which will force a save of pending changes. Otherwise, closing and reopening the .mdb might be your only option.

HTH,

Bob

I tried everything that I could think of. Created a new db, copied in all tables, forms, modules, etc., etc. There are no other references except to the MS libraries needed to compile, and the Replace9.mde. Any more suggestions?

David

Hi David,

The only other thing that comes to mind is you might try splitting the db if it isn't already split. That'll leave your data and application objects completely independent of one another. What type of object are you trying to rename? Does toggling the Tools --> Options --> Advanced --> Default open mode property between Shared and Exclusive have any impact?

Bob

The other slightly weird thing in your case is that error value 3734
is an ADO error, not a Jet or VBA error, associated with the adErrOutOfSpace constant in the ADO ErrorValueEnum. The error description associated with this value is:

"Operation cannot be performed. Provider cannot obtain enough storage space. There might not be enough RAM or hard-drive space for temporary files on the server."

...not the description you are reporting. No idea what thats about.

Bob

Tried the shared/exclusive option - same error. Most of my data is in linked tables - to Oracle. Tried removing these links. Leaves me with a couple of small tables - still the same.

FYI: I a running Windows XP on a 3.06 G processor with 1 G of memory.
My db is on the LAN - my department's server.

Anything else come to mind?

David

Hi David,

I suspect that your problem can be caused by many sorts of reasons, including a corrupt .mdb file, therefore, you can try our product Advanced Access Repair to repair your Microsoft Access databases. It is a powerful Access recovery tool. It can recover deleted tables and records in Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed information about Advanced Access Repair.

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)