473,241 Members | 1,533 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 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 4751
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: Orchid | last post by:
Hello, I have a MS. Access database in XP. When I open the database in design view, users will get an error message & cannot even open the database. Is there any way to solve this problem? ...
5
by: Rey | last post by:
Howdy all. Was wondering if there is any resolution for err 3734: "The database has been placed in a state by user X on machine Y that prevents it from being opened or locked." I've spent...
0
by: Donald Grove | last post by:
I have just begun to use ado to edit recordsets. My problem is that sometimes I get this error message: "The database is in a locked state by user ADMIN on the machine which prevents it being...
0
by: Tommy B | last post by:
I'm currently working on a casino script for an IRC bot. I was going to make a flat file database, but I decided to make it sqlite after some suggestions. I'm using pysqlite. ...
9
by: stuart wieder | last post by:
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked" i need to have multiple users being able to access the...
5
by: rm | last post by:
When using ADO in a module inside an Access 2003 database do I need to open a db connection even though I am working with a table inside the same database? I am writing a bit of code to...
2
by: Briansmi1116 | last post by:
I have a database that I created to be used by several people on a network. Every now and then, when someone has it open, and another wants to open it they get this error; "The database has been...
0
by: =?Utf-8?B?VHVybnBpa2UgSVQ=?= | last post by:
So we have a Xerox x65 set up in all of our business centers. There is a an account ono the server called scanuser. Our networking guys cant figure out why ths account is getting locked out for no...
9
by: ejamnadas | last post by:
Hello, I'm recieving the following run-time error: Database has been placed in a start by user 'Admin" on machine 'Machine' that prevents it from being opened or locked. This is the code...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.