I have an Access 2002 database on a network server. I went to the database, turned on Compact on Close. When I closed the database, I got the message that "DatabaseName.mdb cannot be found". And it was gone! No db1.mdb, no anything. I even searched the drive in case it got moved somewhere, nope!!!
Thankfully, I had a backup copy and only lost a few hours of work, but how can I trust the database to not vanish again once users are using it? Anyone have any idea how a database can vanish?!?