Strange behavior when closing query

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.
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top