how do i connect to a password protected database through VB.......
anud18
0
Junior Poster in Training
Recommended Answers
Jump to PostHi,
If using DAO :
Dim DB As DataBase
Set DB = DBEngine.OpenDatabase("C:\DB1.mdb", False, False, ";PWD=MyPWD")If using ADO:
Set conn = New ADODB.Connection
conn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\DB1.mdb;" & _
"Jet OLEDB:Database " & _ "Password=MyPWD"
conn.OpenRegards
Veena
Jump to PostHi,
That is:
Set conn = New ADODB.Connection
conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\DB1.mdb;" & _
"Jet OLEDB:Database Password=MyPwd"
conn.Open
All 5 Replies
QVeen72
104
Posting Shark
Hi,
If using DAO :
Dim DB As DataBase
Set DB = DBEngine.OpenDatabase("C:\DB1.mdb", False, False, ";PWD=MyPWD")
If using ADO:
Set conn = New ADODB.Connection
conn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\DB1.mdb;" & _
"Jet OLEDB:Database " & _ "Password=MyPWD"
conn.Open
Regards
Veena
QVeen72
104
Posting Shark
Hi,
That is:
Set conn = New ADODB.Connection
conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\DB1.mdb;" & _
"Jet OLEDB:Database Password=MyPwd"
conn.Open
QVeen72
104
Posting Shark
Hi,
I dont know why Icon is being printed.
Jet OLEDB:Database Password
Regards
Veena
QVeen72
104
Posting Shark
Hi,
Replace Icon by ":" (Colon)
anud18
0
Junior Poster in Training
thanx a ton veena......m vry grateful 2 u
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.