• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Programmatically creates a DSN using DAO

Programmatically creates a DSN using DAO

Programmatically creates a DSN using DAO

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

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    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