Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

access database error

Posted on 2013-05-14
11
Medium Priority
?
158 Views
Last Modified: 2014-01-03
When I try to start my Access 2007 database (yesterday I work with this db without problem) I get the message: "The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time."
0
Comment
Question by:dperina
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
  • +2
11 Comments
 

Expert Comment

by:Kryologic
ID: 39166781
Did you try to do a compact/repair?  Tools -> Database Utilities -> Compact and Repair
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39166790
Hi,

Before you do ANYTHING - make a backup of the file.  Then run the compact and repair.

Regards,

Bill
0
 

Author Comment

by:dperina
ID: 39166796
I try buy appear the same mesage
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Expert Comment

by:Kryologic
ID: 39166801
Bill is 100% correct. Always backup your data before doing any of the suggested answers. Also if this database is on a network backup to your local machine and try to open if it opens before the repair. if it opens you are most likely facing a network issue.
0
 

Author Comment

by:dperina
ID: 39166806
the db is in my computer.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39167058
Hi,

If the compact and repair fails to resolve the issue then you will need to create a new blank database and try and import all objects from the existing database.  That may at least salvage some of the work.

Do you have a backup?

Regards,

Bill
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39167268
Close the database and Access.
Look in the folder containing the database.
If there is a file called  yourdatabasename.laccdb then delete it and then re-open your database.

(If you are using a .mdb file then the file to look for is yourdatabasename.ldb )
0
 

Author Comment

by:dperina
ID: 39170113
my db is .mdb and not exist any file *.ldb in the folder

I try to explain the reason for I suscribe to Expert Ex. (sorry for my english)
I work with VB6 and access db (mdb) and more than one ocasion I find this error and look for solution in Internet but I don't could find any work.
In this case the db is for development and don't have critical data; I could delete and rebuid a new, but my preoccupation is -> what happens if this error appear in my client database sistem!! I need have some procedure to recover the critical data if this problem arises.
Thanks in advance for your help.
0
 

Expert Comment

by:Kryologic
ID: 39170201
Have you tried the database on any others machines? Does this problem occur?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39170264
<When I try to start my Access 2007 database>
Any startup code or macros?
0
 
LVL 14

Accepted Solution

by:
Bill Ross earned 1000 total points
ID: 39170285
Hi,

Rather that figuring out how to fix the error, I think you should investigate the cause.

This rare error is usually caused by something left open when the front end is closed.  I would check the VB app VERY closely to make sure you close all connects as soon as they are done.  If you open a form or recordset then make sure the database connection is closed when no longer being used.

It's also good practice and helps performance to open one connection at the opening of the application and close it correctly when the app closes.  Use a hidden form or static recordset to do this.

Hanging connections are very bad when using file based databases.

Stress test your application.  Hit the power switch, dump the LAN, etc. and see if the db breaks.  It should not.

Regards,

Bill
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

722 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