ODBC connection -Please help

[DPUser]

I have a datase that needs to be linked up to a database via an ODBC connection. I have linked up the table in the usual way.
-right click on tables
-select link tables
-click on files of type
-scroll down to ODBC databases
-Go to "Machine Data source" tab
-select desired database
-enter pass/user
-select desired tables
A world icon appears indicating a linked table

I want to be able to insert the name of the database, user and password in textboxes, then VBA would establish an ODBC connection. I would apperciate any help.

Thank you

 

[Bastien]

Can be done, set a up a module (actually two one to open and one to close the connection and clean up) reference the appropriate packages in the reference section and code it like a VB project

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!