Link to home
Start Free TrialLog in
Avatar of KnowledgeWare
KnowledgeWare

asked on

MS Access 2003 mdb opening error 'Data is in an inconsistent state'

I have an MS Access 2003 dbase on a Windows Server 2003 shared drive. It has run flawlessly for many months being connected to a front end Access 2003 mde file on various workstations. Recently the database has begun corrupting and will not open - coming up with a 'data is in an inconsistent state' message when I attempt to open it with Access. Access 2007 repairs the database when I attempt to open it - which is good - however it happens before you open the dbase and I never get to the core of what the problem is. Does anyone know of a way to open/analyze the corrupt database to determine where the issue is occurring so I can cure it? If I knew what tables were originating the problem I could identify the source. TIA
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KnowledgeWare
KnowledgeWare

ASKER

Thanks! It's getting late but we'll try this in the morning and post back.
Might be the OpsLocks issue: http://www.granite.ab.ca/access/corruption/causesoplocks.htm

Could also be dropped network connections, which are one of the most common causes. mx has shown you how to fix your database, but you need to find out WHY this is happening and fix it, otherwise you're fighting a losing battle.

Tony Toews has an extensive collection of corruption info:
http://www.granite.ab.ca/access/corruption
thanks!