Slow openning a local table

[seaport]

For some reason it is very slow to open a local table in one of my Access 2003 database, which is located in my C drive. I have compacted the database many times. The size of the db is about 8M. It is also very slow to open a linked Access/ODBC table. However, it is very quick to open a pass-through query,

Additional information: there are about 40-50 tables (local or linked) and more than 100 queries in the database.

Anyone has a clue about this?

Seaport

 

[PHV]

menu Tools -> Options ...
tab General: disable all tracking options.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[seaport]

PHV,

Thanks for the reply.

Do you tell me more about "tracking options"? Do you mean "Name Autocorrect"? I am using Access 2003 and Name AutoCorrect was disabled.

Seaport

 

[PHV]

Yes, I meant "Name AutoCorrect" but just guessed the english term as I play with a french version of ms-office.

 

[WildHare]

Another thing to consider - if your table is keyed and/or indexed on, let's say, FieldA, but you opened it at one time and sorted it on, say, FieldZ (a non-indexed field), when you closed the table and Access said "Do you want to save the changes made to Table FOO", if you said YES, every time you open the table from then on, Access will SORT it ahead of time in that non-indexed field order..this could be part of your problem.



--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman