ODBC

[Jamie]

Hi,

Any one have an idea how to make a connection in code VBA
for an automatic ODBC from ACCESS to SQL SERVER

Thank you

 

[Cheryl Fischer]

There are some good code samples for DSN-less connections to a variety of
data sources, including SQL Server, here:

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm