DSN-less connection

[Ezekiël]

Hello everybody,

Can someone tell me what the best way is to use a dsn-less connection code.
Should i use it in a form or use it in a module?

Greetings,
Ezekiël

 

[Alex Dybenko]

look at this page
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm

 

[Ezekiël]

Hi Alex,

Thanx for the tip, but can you help me implement the code? Should i use it
in a module of in each form and how can i get the data into my textboxes.

If i can learn that, than i would be very thankful

 

[Alex Dybenko]

well, depends on what you want to achive
if you wan to create linked tables in mdb and update connection string -
best would be to start from here:
http://www.mvps.org/access/tables/tbl0010.htm

HTH