dperina
asked on
access database error
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."
Did you try to do a compact/repair? Tools -> Database Utilities -> Compact and Repair
Hi,
Before you do ANYTHING - make a backup of the file. Then run the compact and repair.
Regards,
Bill
Before you do ANYTHING - make a backup of the file. Then run the compact and repair.
Regards,
Bill
ASKER
I try buy appear the same mesage
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.
ASKER
the db is in my computer.
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
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
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 )
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 )
ASKER
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.
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.
Have you tried the database on any others machines? Does this problem occur?
<When I try to start my Access 2007 database>
Any startup code or macros?
Any startup code or macros?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.