|
Language: Visual Basic Expertise: Intermediate
Aug 21, 1997
Data Access Speed
When you connect to remote servers, always use tables attached to the
server through Access. This will significantly speed up your retrieval
time. Once a table is attached to a remote server, the whole structure
of the table is brought down to your local machine. If it is not attached,
the table structure is brought down the line, followed by your data, every
time you make a query.
Paul D. Sheriff
|