Slow link to backend mdb

  • Thread starter Thread starter Allen Cross
  • Start date Start date
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
 
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
 
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
 
Back
Top