Open ODBC connection

[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é

 

[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

 

[Guest]

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é

 

[Alex Dybenko]

Hi,
you can try to use DSN-less connection string:
http://www.accessmvp.com/djsteele/DSNLessLinks.html

 

[Guest]

Thanks,

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

greetings
René