ODBC connect to DB2

[Chris]

I am trying to link to a DB2 database using code, instead of the pop-up
window. Can I use "docmd.transferdatabase..." to accomplish this? Does
anyone know the syntax for this?

Thanks.

 

[John Nurick]

Hi Chris,

TransferDatabase won't do it, but these links should get you going. Some
of them are quite long, so watch out for wrapping

http://www.able-consulting.com/ado_conn.htm

Setting Connection String Parameters in DAO
http://msdn.microsoft.com/archive/d...nnectionStringParametersinMicrosoftAccess.asp

http://msdn.microsoft.com/archive/d...mAccessingExternalDatawithMicrosoftAccess.asp