Open ODBC connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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é
 
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
 
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é
 
Thanks,

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

greetings
René
 
Back
Top