access/sql server

T

tpkt

I'm currently developing an access db that will be split with an access f.e
..connecting to a sqlserver b.e..
when creating and accesing record sets in code what should be used
ADODB, dao etc
I often get confused over this!

Thanks
 
G

Gijs Beukenoot

From tpkt :
I'm currently developing an access db that will be split with an access f.e
.connecting to a sqlserver b.e..
when creating and accesing record sets in code what should be used
ADODB, dao etc
I often get confused over this!

Thanks
Click to expand...

Simple explanation:
DAO can be used with local and attached tables (linked to, for example,
SQL).
ADO can be used with an ADO-connection (for example, with the correct
driver, to SQL). No attached tables needed.
 
Top