How do I create ODBC System DSN to Access DB in code???

[MoaTad]

Hello,

I want my VB6 app to create an ODBC System DSN for connection to an Access database programatically.

There are plenty of websites (including Microsoft and this forum) that give code on how to create one to an SQL database, but I have not been successful in modifying the process to work on an Access database.

I know there are alternatives to this type of connection, but for better or worse, I am dealing with a legacy app that uses this type of connection. Normally we have the user manually create the DSN via Control Panel, but now we need to do it automatically in the program.

Thanks in advance!

 

[bmdb]

Check out the following site.

http://www.able-consulting.com/ADO_Conn.htm

 

[MoaTad]

PROBLEM SOLVED. After searching for two hours yesterday on this, this morning I found it shorly after posting this message.
Its funny how tweaking your Google search terms a little can radically change your results.

BTW, the solution I found was at:

http://www.thescarms.com/vbasic/CreateDSN.asp

Thanks bmdb for your response and the link! There is a lot of good info there!