to link tables or create recordsets?

[Mike D]

IN doing some initial testing I have found that creating recordsets from a
database in another directory is much slower than a local or direct table
directory.

Is there performance increases by liking to the tables then binding forms
to the tables? Or would I further enhance the performance by linking tables
then creating recordsets off the locally linked tables?

I am in my first initial stages and doing performance testing before actual
design. I will have a 20 user environment connecting to shared data. Without
moving to SQL initially. I am looking for the fastest connection.

 

[Mike Painter]

IN doing some initial testing I have found that creating recordsets from a
database in another directory is much slower than a local or direct table
directory.

Ignoring network connetions there should be no dicernable difference working
with recordsets from linked tables.
A front end sitting on the user's workstation and the tables on a backend
are very common.