Table links and ADO connections confusion ?!?

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

Guest

I'm confused about how to connect to my back end database tables. I set up table links in Access. However since I'm using ADO connections specifying the path to the back end, do I even need these links? Which is more efficient? I'd like to minimize connections to the back end
Also how can I handle SQL calls which access tables and views, since the tables must be accessed in the back end and the queries on the client
Can anyone throw some light on this?
 
Either put the queries on the back end and use ADO, or put the queries at
the client and use linked tables.

If you use queries at the client you need linked tables: If not, you can
use ADO connections.

Also, linked tables cache differently than ADO connections. This my either
be good, or bad.

(david)


David said:
I'm confused about how to connect to my back end database tables. I set up
Click to expand...
table links in Access. However since I'm using ADO connections specifying
the path to the back end, do I even need these links? Which is more
efficient? I'd like to minimize connections to the back end.
Also how can I handle SQL calls which access tables and views, since the
Click to expand...
tables must be accessed in the back end and the queries on the client?
 
Back
Top