Solved

Run time error - (-2147467529 (80004005))

Posted on 2013-12-12
7
619 Views
Last Modified: 2014-06-17
I can successfully run some codes in a standard module and create recordsets
for an query. However, if I want to run this module again, I will always get
the above run time error and a msgbox "The database has been placed in a
state by User"Admin" on machine "xxxx" that prevents if from opened or
locked". I can only then run the module by shutting down Access and then run
it again.

This is very time consuming and annoying.

The only thing I found on the web was that something must be open. But I close everything I can think of. Please advise....

My code is attached in a text file....
errors on :  conn.Open sConnString
code.txt
0
Comment
Question by:baytowel
  • 5
7 Comments
 
LVL 10

Expert Comment

by:Anthony Berenguel
ID: 39714569
I'm not sure if this is the problem but try setting 'conn = nothing' after you close the connection.
0
 

Author Comment

by:baytowel
ID: 39714822
This didn't help.....
0
 

Author Comment

by:baytowel
ID: 39714864
If I make a change in any module in the project, I receive the error!!! Even if I have not run the module yet!!!!
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 38

Expert Comment

by:Jim P.
ID: 39720571
At the top of the offending module put Option Explicit if it isn't there already.

Then go in to Tools --> References and make sure nothing says MISSING Then do a Debug --> Compile. The cause could be a missing reference or an error in another module.
0
 

Author Comment

by:baytowel
ID: 39807087
Option explicit does exist at the top of the module and nothing missing in references and a compile completes....
0
 

Accepted Solution

by:
baytowel earned 0 total points
ID: 40131029
Closing due to no solution
0
 

Author Closing Comment

by:baytowel
ID: 40138850
EE was not able to provide a solution
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Import New Records From Access Table To SQL Database Table 7 31
Reading the code behind a form - via VBA 3 31
Access 2010 change CurrentUser 5 33
Sum in Split Form 17 27
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question