Setting up DSN through Code

M

Mark A. Sam

I am considering writing and distributing a small Access app which links to
an SQL database through the internet and wonder how the application can set
up a DSN on the users machine and link the necessary tables. Is there some
code that someone can give me to accomplish this?

Thanks and God Bless,

Mark A. Sam
 
D

Duane Hookom

You can make sure a reference is set to the DAO object library and use the
RegisterDatabase method. You can also use vbscript to create DSNs by
creating registry entries.
 
Top