Faster Linked tables

[GBalcom]

The following article describes how holding a lock on a linked table helps speed up the application. Does this still apply to linked tables that are SQL server based?

http://www.fmsinc.com/MicrosoftAccess/Performance/LinkedDatabase.html


If so, how would you modify the above code to hold a lock on an server based table?

 

[Ranman256]

Linked SQL tables do not present slower.
Use indexed tables,
Fast newtork cards ,CAT6 cable,query design.