Database keeps getting placed in a locked state

[tricard]

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

[Salad]

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