mdb ran out of space on disk - all queries deleted !?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My user was running an mdb and ran out of space on her disk. What we have now
is a database where every query just says 'SELECT;'

Is this a known bug?
 
At times like this, nothing beats a good backup. In fact make a complete
backup of the database now and put it away for safe keeping. Then try doing a
compact and repair. If that doesn't work, you may need to create a new
database and import your tables into it and all your queries, forms, etc.,
from a recent backup.

Actually you have found out the hard way one of the many reasons for
splitting your database between a front end and back end. Had they been split
your queries should not have corrupted.
 
This database is split.
I think what you meant is running an mde instead of an mdb would provide
that protection.

Dorian
 
I think what Jerry meant was if you were using SQL Server the queries
would not have come to any harm as they are stored on the server or
back end! However this is only true of an access data project.

I hate to be the one to tell you mscertified but I don't think that an
mde affords any more protection to queries than a mdb.

Good luck

Nick
 
Actually an MDE can provide more corruption protection to forms, reports, and
modules as they are compiled. Probably no more help on queries and tables
though.
 
Back
Top