Speed up Access linked tables
Posted on 2011-05-06
I have to mdb files. One that is used as front end (is placed local on the users computer) and one mdb file with data that the users work with. All tables are therefore linked. The mdb file with the data is placed on a network drive, and is therefore a bit slow. But i found out something funny. If i add 14000 rows from a linked table (the data mdb) to a local table (the front end mdb) it takes about 16 sec. But if i do the same procedure while having the data mdb open it takes 1 sec.
That is fast, but is there a way I can have this data mdb open so the system is fast without the users can see it?