Link Table

D

Dornig Uros

I have question about link SQL tables in access mdb (2003). I know for three
metods of link tables: DAO, ADO and docmd.TransferDatabase...... .
Which type of link is better?
What is difference between?
Which metod is recommendation?

Thanks
 
P

Pat Hartman

The most efficient method is to link them via the GUI and just leave them
linked. Linking tables on the fly, regardless of method, adds a great deal
of overhead. Each time a table is linked, Jet needs to have a conversation
with the data provider and obtain and store information about the table and
about services that the data provider provides. Leaving the tables linked
permanently, eliminates all this overhead at runtime.
 
Top