Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Unexpected State - DAO error message


Message #1 by alanhawkins.home@d... on Mon, 5 Mar 2001 17:03:37
I have written an application that was upgraded from V97 to 2000 and after 

some time a crash occurred causing an error message (the longest in 

existence????) to appear stating "The database is in an unexpected 

state..." and suggesting that the cause was that a DAO CompactDatabase 

method had been used (it hadn't) and suggesting that the Convert Database 

option on the Tools menu be used (you can't as you can't open it or import 

it). It also suggests recreating the database and just importing the 

tables and queries. A graphic of the entire message box is available!



I created a new database from scratch, using Access 2000, with new forms 

and imported the tables, queries, reports and macros from an earlier 

backup. I have used no modules and hardly any code as I have used the 

macros instead.



This has worked fine for a few weeks and now it has happened again!  At 

the time a report was being print/previewed.



I can find no mention of this particular error on the MS Knowledgebase. 



It is running on a small NT BackOffice system with NT workstations.



Has anyone any ideas please!


  Return to Index