DAO Connection Code for MS SQL

[MacDaddyNickP]

Does anyone have code example of using a connection to a MS SQL backend database? I'm new at this and would appreciate any help there is out there.

 

[PHV]

Have a look 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

 

[MacDaddyNickP]

Thanks PHV. Do you have any sample code for implementing a Connection object to SQL using DAO syntax? Also, If I use a ADOB connection, must I then use ADOB syntax to access the data contained therein?