• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• This can be used to Create DSN at run time

This can be used to Create DSN at run time

This can be used to Create DSN at run time

Rate This can be used to Create DSN at run time

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Project -> Refenece -> select microsoft dao 3.6

'put the following code in the procedure where you want to register DSN

    dao.RegisterDatabase "CheemoBackup", "Microsoft Access Driver 
(*.mdb)", True, "DBQ=" & Trim(App.Path & "\transfer\CheemoData.mdb") & vbCr 
& "OemToAnsi=No" & _
            vbCr & " Database=" & Trim(App.Path & 
"\transfer\CheemoData.mdb")