Link to home
Start Free TrialLog in
Avatar of Andy Brown
Andy BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Hidden queries with "~sq_f" and "~sq_r"

I'm having a bit of a weird issue with Access that I have a question currently open for.  However, on a possibly related note, I would like to know what the above query prefixes are and can I delete/rebuild them from scratch?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andy Brown

ASKER

Fair enough.....

Thanks Scott.
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

adding on ... ~sq_f are probably internal queries built for forms and, likewise, ~sq_r for reports.

If you delete these, they will be rebuilt as they are needed (you might get an error that ~blah-blah was not found -- just click OK).  It is a good idea, imo, to delete them every now and then since there may be some that are no longer used.  After doing this, compact/repair the database ... and, of course, back it up before you do anything