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!