I've received the following message from Access and I would like to know what may have caused it if anyone can help. Please keep in mind when you read this that this database was NOT converted from any prior version of Access, however, it is set up to compact automatically on close, but I've never had that cause something like this. Thanks!
"This database is in an unexpected state; Microsoft Access can't open it.
This database has been converted from a prior version of Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state.
If you have a copy of the database in its original format, use the Convert Database command on the Tools menu (Database Utilities submenu to convert it. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered."