Time to open a table seems unusually long

P

Paul Ponzelli

I've noticed in one of my databases that it takes about 5 secondes to open
any of the tables in datasheet view (after double-clicking on the table icon
in the database window), while most of the tables in my other databases open
almost instantaneously. All of these tables are resident in their front end
mdb file; that is, they're not linked to another database file.

This condition persists regardless of whether the mdb file is in a local
network drive or my own C: drive. It takes them about 5 seconds to display
in datasheet view.

I'm concerned about this because I believe that whatever is causing this, is
also affecting the performance of my queries, forms and reports. What could
cause this delay in opening these tables?

Thanks in advance,

Paul
 
A

Allen Browne

If the table is local (not attached), this should do it:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation:
http://allenbrowne.com/bug-03.html

2. Open the table in design view.
Open the Properties box (View menu).
Set SubdatasheetName to: [None]
Save. Close

3. Compact the database:
Tools | Database Utilities | Compact

More info and options in the Access Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm
 
P

Paul Ponzelli

Now it's much better. Thank you, Allen.

#2 (below) was the main culprit in my case.

PP


Allen Browne said:
If the table is local (not attached), this should do it:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation:
http://allenbrowne.com/bug-03.html

2. Open the table in design view.
Open the Properties box (View menu).
Set SubdatasheetName to: [None]
Save. Close

3. Compact the database:
Tools | Database Utilities | Compact

More info and options in the Access Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Paul Ponzelli said:
I've noticed in one of my databases that it takes about 5 secondes to
open
any of the tables in datasheet view (after double-clicking on the table
icon
in the database window), while most of the tables in my other databases
open
almost instantaneously. All of these tables are resident in their front
end
mdb file; that is, they're not linked to another database file.

This condition persists regardless of whether the mdb file is in a local
network drive or my own C: drive. It takes them about 5 seconds to
display
in datasheet view.

I'm concerned about this because I believe that whatever is causing this,
is
also affecting the performance of my queries, forms and reports. What
could
cause this delay in opening these tables?
Click to expand...
Click to expand...
 
Top