Cannot Open Access Database 1

[matth]

I am trying to open a database, but I am getting the following error:

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 have tried to rename the file, move it to another computer, but I can't open it. I have tried to run the compact and repair, but it responds with the same message. I also tried to use the Jet Compact utility and cannot make open the database. Any suggestions?

Thanks in advance,

Matthew

 

[matth]

Here's an update:

From another post, I have tried to use the /decompile command line option. I am still getting the same message from Access.

Still looking for answers.

Thanks in advance,

Matthew

 

[beetee]

You might try creating a new database, and importing all the objects from the corrupt database into the new database.

 

[matth]

Excellent idea to try to import object from the corrupt db. I have tried the idea, and unfortunately it was unsuccessful. Thank you for the idea, beetee.

Any other suggestions out there?

matth

 

[beetee]

OK, when all else fails, invoke your favorite search engine using the error message.

http://msdn.microsoft.com/chats/office/Office_100302.asp

search the page for 'stopped'

 

[matth]

I had checked through the MS Newsgroups and KB before posting to Tek-Tips. According to the steps I went through (Q283849), they think its lost. Last time I read that, someone on Tek-Tips introduced a better solution. I was hoping for another stroke of luck.

Thanks again,

matth

 

[annsolomon]

I wonder if this might help in your case:

http://www.experts-exchange.com/Databases/MS_Access/Q_10247284.html

Ann

 

[KLewisBPM]

Matth,

Just a quick thought whilst i was browsing. Have you checked that the file hasn't been locked by the server. If your running a server it might be worth having a look too see if it thinks the file is still in use by somebody and therefore locked.

Probably not any help! but you never know!

Kind Regards

Kelley Lewis

 

[matth]

Thank you for the input Ann and Kelley.

As an update, the file is not currently locked by the server (no .ldb file and I checked to see if anything else had claim to the file). As well, the link provided an interesting idea, but through our trials last night, I tried to open the file from 6 different locations: 2 Win 2k, 2 NT 4 Workstations, and 2 Win 98 SE with no success.

Its a shipping database accessed by UPS Worldship using ODBC. I put together a new database with current data last night to get my packages out, but I am just about to the point to try a recovery service to get my old data back.

Thanks again for the suggestions,

matth

 

[BBaggins]

I see this error about once a month. Your database is corrupt, and the Access Repair feature will not fix it.

Here's how I deal with it:

First, I wrote a little program that makes a copy of my development database, deletes all the data from it, and then compacts it. I keep a copy of this empty database and call it template.mdb.

I then wrote a second program that just copies all the data from a corrupt database (in the right sequence to satisfy referential integrity rules) into the template. In the copy table function I have an elaborate error handler that gives me the option of skipping the current record, skipping the current table, or skipping the current field (and inserting a default value). With this tool I have had a 99.9% success rate salvaging broken databases.

Sorry, I can't give the tool to you because it was written specifically for my application and wouldn't do you any good. However, it's not a difficult program to write.

 

[matth]

Well, I am not surprised that someone would have a solution (these forums have solved 100% of my issues so far). I have a few questions though.

Do I need to make the template db ahead of time? Since we couldn't open the corrupt db, I can't remember the layout.

I will have to find a way to get that set up.

Thanks again for your help.

matth