Programmatically creates a DSN using DAO

by Sameer Kamat (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Thu 29^th August 2002
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

API Declarations
Dim dbE As New DAO.DBEngine Dim strAttr As String 'used to define the attributes to be specified for the DSN

Rate Programmatically creates a DSN using DAO



    strAttr = strAttr & vbCr & "description=programmatically created DSN" 'description
    strAttr = strAttr & vbCr & "pwd=a" 'password
    strAttr = strAttr & vbCr & "uid=admin" 'login name

    db.RegisterDatabase "myDSN", "Microsoft Access Driver (*.mdb)", False, strAttr

Download this snippet Add to My Saved Code

Programmatically creates a DSN using DAO Comments

No comments have been posted about Programmatically creates a DSN using DAO. Why not be the first to post a comment about Programmatically creates a DSN using DAO.

Programmatically creates a DSN using DAO

Programmatically creates a DSN using DAO Comments

Post your comment

Difficulty