Urgent! "Access Error Message" Urgent!

Bobscooks

New Member
Joined
Jan 5, 2006
Messages
12
Im trying to open a database that I use at work that a lot of important daily reports are built off and I am getting the following message:

'The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.'

I am getting this straight after trying to open the file, if I click okay I am left with a session of access runnning with no open database, and click help does nothing at all.

I urgently need to get this resolved. Any solutions.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
Hi

It sounds like your database has become corrupted. Have a read of this article :
http://support.microsoft.com/kb/182867/EN-US/

Before you do anything, make a copy of the database.

Check there is no-one else using the database and try compacting and repairing the database. This probably won't succeed but it is still worth trying.

If that fails, see if there is an identically named file in the same directory with the 'ldb' extention (rather than the 'mdb' extension). If there is no-one else using the database delete the 'ldb' file and try to open the database again.

If that fails, read the article above - it contains a link to a 'jetcomp' utility - download and run that utility. (see here : http://support.microsoft.com/kb/172733/EN-US/)

If that also fails, there are a number of online service providers who can help restore corrupt databases, Google turned up this one for example :
http://www.accessdatabaserepair.com/

HTH, Andrew

P.S. have you tried creating a new database and importing the tables etc out of the old database?
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
With Access closed, check in the folder that holds the database and see whether there is a .ldb file with the same name as the database (which will have a .mdb extension).

If so, delete this file and try opening your database again. Explanation: Every time you open your database, Access creates a .ldb to track who is in the database. If Access crashes or there is a network problem, the .ldb is left behind instead of being deleted).

Denis
 

Bobscooks

New Member
Joined
Jan 5, 2006
Messages
12
Thank you.

Tried the above, but with no success. There is no ldb file, and the other methods just return the same or similar error messages.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
OK, it sounds like you do have corruption issues.

Here are 2 MS links with some background:
Access 97 -- http://support.microsoft.com/kb/279334/EN-US/
Access 2000 -- http://support.microsoft.com/kb/209137/EN-US/

One option is to import all objects into a new, blank database.
1. Create a blank database
2. File > Get External Data > Import
Select all tables, then OK
Repeat in turn for queries, forms, reports, macros, modules
At some stage your import will fail -- note the name of the object, that is the source of the corruption. Continue wit the remaining objects in the DB. Unless you are very unlucky, there won't be more than one corrupt object.
3. If you created any custom menus and toolbars, click the Options on the import dialog and import them too.

Now that you have a DB without the corrupt object(s), restore these from a recent backup. If you don't have a recent backup you will need to rebuild them, or invest in a database recorvery service.

For future reference, it is a good idea to regularly compact and repair the database (Tools > Database Utilities > Compact and Repair). It keeps everything running smoothly and reduces the chances of corruption.

Denis
 

Forum statistics

Threads
1,136,990
Messages
5,678,983
Members
419,797
Latest member
ikethegenius

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top