We have recently converted from Access 97 to Access 2010. One of our databases keeps going into an inconsistent state. Any suggestions as to what may be causing this and any posssible solutions?

tesla764
tesla764 used Ask the Experts™
on
We have recently converted from Access 97 to Access 2010. One of our databases keeps going into an inconsistent state. Any suggestions as to what may be causing this and any posssible solutions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
Well ... you have to admit ... 'inconsistent state' is a bit vague and nothing to go on. You will need to provide a LOT more information ....

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
In the meantime, you may want to look over the excellent information contained here, regarding converting to A2010:

http://www.allenbrowne.com/Access2007.html

mx
It means that your database is problably corrupted.

http://www.granite.ab.ca/access/corruption/symptoms.htm

I hope you have a back-up, if so try importing everything into a new database.  
Check also below articles:
http://www.granite.ab.ca/access/corruption/retrievedata.htm
http://allenbrowne.com/ser-25.html

HTH,
Daniel
Top Expert 2011
Commented:
I have had lots of issues with Access 2010 converting databases.

I have found it best to create a new blank .accdb and import the objects from the older versions. II have had lots of issue with built in convert in Access 2010.  Also this method seams to work better with Access 2007.
 
Boyd aka HiTechCoach
Microsoft MVP - Access

Author

Commented:
Thanks Everyone.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial