471,080 Members | 1,176 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,080 software developers and data experts.

Database keeps getting placed in a locked state

Good afternoon all,

I have recently been trying my hand out at the ADO model as before I
have only used DAO (just thought I would expand my knowledge a bit).
The problem I am having is that while I am executing and debugging
code, my database keeps getting put into a locked state and I cannot
seem to get it out of this state without closing MS Access and
reopening it (and this doesn't seem to always work either).

I used to have this problem with DAO, but I worked around it by
rolling back any transactions I had pending simply by referencing
DBEngine(0) and performing the ws.rollback method. I thought I would
try this on the ADO model as well, except I don't even have the
opportunity to connect without the error occurring.

The exact error is as follows (and happens right before I attempt
con.open strSQL)

ERROR CODE: -2147467259 (80004005):

THE DATABASE HAS BEEN PLACED IN A STATE BY USER 'ADMIN' [that's me] ON
MACHINE 'INTEL3G' [that's my machine] THAT PREVENTS IT FROM BEING
OPENED OR LOCKED

Any help would be appreciated and if more info is needed, then just
let me know.

Tim

Aug 9 '07 #1
1 4586
tr*****@gmail.com wrote:
Good afternoon all,

I have recently been trying my hand out at the ADO model as before I
have only used DAO (just thought I would expand my knowledge a bit).
The problem I am having is that while I am executing and debugging
code, my database keeps getting put into a locked state and I cannot
seem to get it out of this state without closing MS Access and
reopening it (and this doesn't seem to always work either).

I used to have this problem with DAO, but I worked around it by
rolling back any transactions I had pending simply by referencing
DBEngine(0) and performing the ws.rollback method. I thought I would
try this on the ADO model as well, except I don't even have the
opportunity to connect without the error occurring.

The exact error is as follows (and happens right before I attempt
con.open strSQL)

ERROR CODE: -2147467259 (80004005):

THE DATABASE HAS BEEN PLACED IN A STATE BY USER 'ADMIN' [that's me] ON
MACHINE 'INTEL3G' [that's my machine] THAT PREVENTS IT FROM BEING
OPENED OR LOCKED

Any help would be appreciated and if more info is needed, then just
let me know.

Tim
Ahhhh...the beauty of google groups. Others have shared your pain.
Check this link out and see if there's any hope.
http://groups.google.com/groups?as_q...=2007&safe=off
Aug 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Orchid | last post: by
reply views Thread by Tommy B | last post: by
reply views Thread by =?Utf-8?B?VHVybnBpa2UgSVQ=?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.