dsn programmatically

User avatar
sal21
PlatinumLounger
Posts: 4339
Joined: 26 Apr 2010, 17:36

dsn programmatically

Post by sal21 »

I need to create via VB6 classic an Access DSN based a database in \\mylan\dir1\mymdb.mdb, but check before to create the new DSN, if just exists with the same access database from the same lan dir...
Possible?

User avatar
HansV
Administrator
Posts: 78379
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: dsn programmatically

Post by HansV »

Why do you want to create a DSN? It's easy to create a DSN-less connection.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4339
Joined: 26 Apr 2010, 17:36

Re: dsn programmatically

Post by sal21 »

HansV wrote:Why do you want to create a DSN? It's easy to create a DSN-less connection.
Experiment for pass-throu query

User avatar
HansV
Administrator
Posts: 78379
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: dsn programmatically

Post by HansV »

But why do you need to create the DSN programmatically? :scratch:
Best wishes,
Hans