468,752 Members | 1,312 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,752 developers. It's quick & easy.

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 4444
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.