Fixing a Database...

[JaedenRuiner]

Helo,

I am trying to resolve a minor issue with a companies database that is somewhat important to them. During one of the many crashes and other issues presented by the computer it operates on, a glitch occurred in the database, and I am hoping to find a way to resolve it.

I have tried using DAO.OpenDatabase, as well as just double-clicking on the .mdb file, and either way i get this 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.

Of course, this is not the case, nobody else is even trying to access the database, however due to security concerns of the original design, the database is sort of stuck in a loop. Is there a programmatic way, via VB, DAO, or ADODB to call out to the database and "reset" this issue. Via an "update()" call, or a "logoff" call, or eh, maybe even an "open readonly" which will allow me to view and copy the data within.

Thank you,

Jaeden "Sifo Dyas" al'Raec Ruiner

 

[RuralGuy]

Have you tried opening the db while holding down a <SHIFT> key?

 

[JaedenRuiner]

I just tried that....

• using explorer to double click (while holding the left, and/or right shift keys)
• using File|Open from Access (while holding the left and/or right shift keys)

Neither worked, I recieved the same error message from Access.

Jaeden "Sifo Dyas" al'Raec Ruiner

 

[RuralGuy]

Have you tried creating a *new* empty db and importing everything from the other db?

 

[JaedenRuiner]

Tried that too, same result.

I need a way that I can send a message to the database convincing it that it's closed, or that whatever user that had been accessing it no longer is.

Jaeden "Sifo Dyas" al'Raec Ruiner.

 

[RuralGuy]

Did it leave the ldb file? If so then just delete it.

 

[JaedenRuiner]

Nope...no ldb file...jus the mdb.
Jaeden "Sifo Dyas" al'Raec Ruiner

 

[RuralGuy]

I've exhausted my bag of tricks. Let's hope someone else drops by with some new ideas.

 

[John.Woody]

Have you tried moving the database to another PC? I take it it is not split in to Front end and Back end

 

[JaedenRuiner]

Yes...
The original database was a 'UPS worldship" database of address and shiped items for the company i do work for. It got corrupted and the ups people told me it was lost, because they don't support access or other database work. But being an access programmer I figured i'd give it a crack, so i uploaded the mdb to my ftp site, and downloaded it here at home. And i'm still recieving the error here.
What i've basically tried is to use DAO in a temporary database with only a form and some VB code to attempt to connect to the DB and access its tables. If i can get it to open up in a readonly nature, i can at least export the data, i don't need the actual file, and though the data isn't crucial, it would be nice to retrieve.

Jaeden "Sifo Dyas" al'Raec Ruiner

 

[John.Woody]

If the db is in an older version such as Access 97 you could try converting it to Access 2002 or 3??