By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,056 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,056 IT Pros & Developers. It's quick & easy.

Working with SQL Servers From Access VBA

P: 16
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.
Apr 2 '12 #1

✓ answered by 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)

Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Apr 2 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.