Creating an ODBC connection in Access VBA

[RYapp]

Hi,

Ive had a search on how to create an ODBC connection using Access VBA,
although any examples i find are for Excel and do not work.

It doesnt matter if it is a file, system or user dsn, if this makes
any difference.

If anybody can help, it would be greatly appreciated.

Thanks,

Russell

 

[Clifford Bass]

Hi Russell,

Get your connection string information from the very useful
<http://www.connectionstrings.com/default.aspx> site. Click on the DSN link
under Miscellaneous for using a DSN. For ODBC connections without a DSN
(DSNless connections) choose the individual database/data file section and
then look for the part that tells about the database/data file's ODBC driver.

Clifford Bass