Open ODBC connection

R

René

Hello,

My access db has linked tables to another db (not access). I get information
from these tables using ODBC. Every time I get information I'm prompted with
the ODBC login form.
How do I open de ODBC connection using VBA?

Thanks
René
 
A

Alex Dybenko

Hi,
you can try to save login info together with connection string when you
create linked table, for example for SQL server this works fine
 
R

René

Yes, I know, but that would mean I have to create a DSN on every computer
that uses the database. That's not what I want, so I'm looking for the VBA
solution.

René
 
R

René

Thanks,

I found code that creates a new DSN. Also a solution that works for me.

greetings
René
 
Top