Creating an ODBC connection in Access VBA

  • Thread starter Thread starter RYapp
  • Start date Start date
R

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
 
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
 
Back
Top