Setting up DSN through Code

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


.

Relevant Pages

  • Re: Access Viewer
    ... > of an Access app. ... I would truly appreciate a reference or a link where I can ... I've been searching for one on the Internet for the past hour or so, ...
    (microsoft.public.access.forms)
  • Re: To DMZ or not DMZ
    ... I am not sure why you wish to change the current configuration if it is ... > I have an sql database that is accessed both from Intranet and a few ... > users on the Internet. ... > the database server on a DMZ and set up a second one for internal ...
    (microsoft.public.sqlserver.security)
  • To DMZ or not DMZ
    ... I have an sql database that is accessed both from Intranet and a few ... users on the Internet. ... I am having a hard time deciding whether to put ... the database server on a DMZ and set up a second one for internal ...
    (microsoft.public.sqlserver.security)
  • Re: Passwording on Links to SQL Database
    ... When you create an ODBC link there's a check box to 'save ... >I have an Access app with tables that are links to an SQL ... >The SQL database requires an 'sa' login with password. ... >this little exercise? ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL Connection via Internet
    ... I have offsite staff and would like for them to connect via the internet and ... ODBC to a SQL database on the SBS 2000 box. ... > internet, meaning you are not allowed to license wise. ...
    (microsoft.public.sqlserver.setup)