Linking Tables

[dzisaacs]

I know it's possible to link tables between Access and SQL Server using ODBC....however can u use DAO to do this? If there's a way i would appreciate some help. Thanks in advance.

 

[PHV]

Have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

and here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886