can't delete a query

  • Thread starter Thread starter howard
  • Start date Start date
H

howard

I have a mystery query called ~sq_csfrmModules~sq_cGradeId
which I cannot view (it tells me I need read design
permission), or delete (requires modify design permission).
The database does not have anything other than default
security, and compacting the database doesn't get rid of
it. The database is Access 97
 
If it's not hurting anything, you can ignore it. If it's causing you to
lose sleep, then it's not a bad idea to copy all _needed_ objects to a new
database every once in a while. This process really cleans house.

Create a new mdb.
Choose File / Get External Objects / Import from the Main Menu.
Select all desired/needed objects
Click More to get toolbars and import/export specs

After the import is complete, open any module and compile with debug /
compile

Finally, repair and compact.
 
Back
Top