tomjones735
asked on
OPEN Encrypted access database using DAO
I am trying open the database password projected encrypted database. I am using below code to open the database. Its not opening. Its giving error messgae.
Dim db As DAO.Database
Dim sql As String
Dim ws As DAO.Workspace
Dim oconn As String
Dim recupdate As DAO.Recordset
Dim recmaster As DAO.Recordset
Dim recflowmaster As DAO.Recordset
Set ws = DBEngine.Workspaces(0)
oconn = "Provider=Microsoft.Jet.OL EDB.4.0;" & _
"Data Source=C:\bankstaffing\SSP -LCR.mdb;" & _
"Jet OLEDB:System Database=c:\bankstaffing\s ecured1.md w,myUserna me, myPassword"
Set db = ws.OpenDatabase _
("C:\bankstaffing\SSP-LCR. mdb", False, False, oconn)
I am getting this error message.
Runtime Error '3151'
ODBC - - connection to 'C:\bankstaffing\SSP-LCR.m db' failed.
Dim db As DAO.Database
Dim sql As String
Dim ws As DAO.Workspace
Dim oconn As String
Dim recupdate As DAO.Recordset
Dim recmaster As DAO.Recordset
Dim recflowmaster As DAO.Recordset
Set ws = DBEngine.Workspaces(0)
oconn = "Provider=Microsoft.Jet.OL
"Data Source=C:\bankstaffing\SSP
"Jet OLEDB:System Database=c:\bankstaffing\s
Set db = ws.OpenDatabase _
("C:\bankstaffing\SSP-LCR.
I am getting this error message.
Runtime Error '3151'
ODBC - - connection to 'C:\bankstaffing\SSP-LCR.m
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.