Working with SQL Servers From Access VBA

[Marc Brown]

I am just starting to work with a connection between SQL Servers and Access using vba. I was wondering if anyone knows of some good sites that show the basic functionality as well as how to connect and set up recordsets from the SQL server.

Thanks for the help.

[nico5038]

I use the Access data project (.adp ) to connect with MS SQL.
(The connection can be set under the "file" menu)
This will open all tables and allow the VBA to use recordset processin from VBA directly on the MS SQL tables as if they were "internal".

Nic;o)