Slow link to backend mdb

A

Allen Cross

I have a 300MB backend mdb.
If I create a new MDB and add a trivial table to it, then
of course opening the table in gridview is fast.
If I link to a table in the backend mdb, then opening the
local table takes 40-50 seconds.
VBA code to either the local or linked table is fast.
Any ideas what is slowing down even the access to the
local table.
Thanks, Allen
 
C

chas

Hi Allen,

If you are using Access 2000 on Windows 2000 make sure
that you have turned off 'Name AutoCorrect' via
Tools>Options>General

hth

chas
 
T

TC

Perhaps a sort condition attached to the "gridview"? (by which you probably
mean, "datasheet view")

Try opening the table in datasheet view, right-clicking (I think: I don't
have Access here to check), then clicking "remove filter/sort", Ctrl-S (to
save that removal), close the datasheet, then try again.

Or maybe the delay is not so much opening the table, but opening the
back-end database. That will often take a few seconds.

HTH,
TC
 

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

Similar Threads

Link updates are very slow 6
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Multiple tables or multiple mdb files? 4
How to security the backend mdb 10
How to add new fields to linked table in backend MDB using code. 2
Add fields to backend's table 12
Use of Linked tables via ODBC to SQL server over wi-fi 3
SQL Server Backend: linked tables or no more bound forms ? 4

Top