Link Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

DAO vs ADO 5
MDB with only linked tables growing tremendously 15
Delete a backend table 2
Linking tables when changed dont display correct data 2
Record-Locking remains open after closing 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
form won't update, what to check 2
Access 2007 + SQL Server 7

Back
Top