Problem: Slow query design window using linked a tables over network.

[Graham Wideman [Visio MVP]]

Hi folks,

I have a problem of extremely slow query design window open and save
operations.

Same query design that opens or saves more or less instantly when it doesn't
involve linked tables, instead takes 10 to 30 secs to open or save when
linked tables are involved.

Example:

MyDB.mdb is located on a samba network share.

MyDB.mdb contains some tables, and some links to other tables, in say
Common.mdb.

For queries that refer only to tables within MyDB.mdb, the query design
window opens immediately, and any changes can be saved immediately.

For queries that include linked tables (ie: tables are in Common.mdb),
opening the query design window takes 10 to 30 secs, and similarly to save
the query.

Somewhat paradoxically, actually running the culprit queries (eg: a SELECT
query producing a result grid), starts showing results in just a second or
two.

Anybody have any ideas on this?

Graham

 

[Lord Kelvan]

you could try delinking the tables and re linking them alternativally
create a new db and import all objects or worst case senerio re
install access