Strange behavior when closing query

  • Thread starter Thread starter ag
  • Start date Start date
A

ag

My database screen blanks out momentarily when I close a
query. It doesn't do that with forms or tables. Any idea
what might be causing this? It's Access2k and the size is
only 10MB.
 
Suggestions:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Open each of your tables in design view.
Open the Properties box (View menu).
Set the SubdatasheetName to: [None]

3. Compact the database to get rid of the gunk (including Name AutoCorrect
info from step 1):
Tools | Database Utilities | Compact

That should solve the problem. If not, and particularly if the data is in
attached tables, see Tony Toews "Performance FAQ" for more suggestions:
http://www.granite.ab.ca/access/performancefaq.htm
 
Back
Top