By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Database keeps getting placed in a locked state

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.