VB & Database, Password protect an Access MDB

ThomasL
#1 / 6

Password protect an Access MDB

Here are the connect strings I have tried:

1.
mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Test.Mdb;Password='pwd'"

Error: Could not find installable ISAM

2.
mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Test.Mdb;pwd='pwd'"

Error: Could not find installable ISAM

3.
mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Test.Mdb;Jet OLEDB:Database Password='pwd'"

Error: Could not find installable ISAM

Help,
ThomasLL

Tue, 30 Aug 2005 21:58:01 GMT

#2 / 6

Password protect an Access MDB

Fri, 19 Jun 1992 00:00:00 GMT

ThomasL
#3 / 6

Password protect an Access MDB

Quote:

>-----Original Message-----
>Here are the connect strings I have tried:

>1.
>mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\Test.Mdb;Password='pwd'"

>Error: Could not find installable ISAM

>2.
>mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\Test.Mdb;pwd='pwd'"

>Error: Could not find installable ISAM

>3.
>mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\Test.Mdb;Jet OLEDB:Database Password='pwd'"

>Error: Could not find installable ISAM

>Help,
>ThomasLL
>.

Tue, 30 Aug 2005 22:20:32 GMT

#4 / 6

Password protect an Access MDB

Fri, 19 Jun 1992 00:00:00 GMT

mike
#5 / 6

Password protect an Access MDB

Try
msConnectionString = "Provider=" & DB_PROVIDER & ";" & _
"Data Source=" & msDataBaseName & ";" & _
"Jet OLEDB:Database Password=" & msPassword & ";"

where for you PROVIDER ="Microsoft.Jet.OLEDB.4.0"
msDataBaseName ="c:\Test.mdb"
msPassword = "pwd"

you don't need the single quotes around the pwd
mike

Quote:

>-----Original Message-----
>Here are the connect strings I have tried:

>1.
>mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\Test.Mdb;Password='pwd'"

>Error: Could not find installable ISAM

>2.
>mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\Test.Mdb;pwd='pwd'"

>Error: Could not find installable ISAM

>3.
>mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\Test.Mdb;Jet OLEDB:Database Password='pwd'"

>Error: Could not find installable ISAM

>Help,
>ThomasLL
>.

Tue, 30 Aug 2005 22:34:21 GMT

Deepak Dembl
#6 / 6

Password protect an Access MDB

I too had the same problem. Try this out

oConn.Open "DSN=MyDSN"
oConn.CursorLocation = adUseClient

Hope this helps :)

Quote:

> Try
> msConnectionString = "Provider=" & DB_PROVIDER & ";" & _
> "Data Source=" & msDataBaseName & ";" & _
> "Jet OLEDB:Database Password=" & msPassword & ";"

> where for you PROVIDER ="Microsoft.Jet.OLEDB.4.0"
> msDataBaseName ="c:\Test.mdb"
> msPassword = "pwd"

> you don't need the single quotes around the pwd
> mike

> >-----Original Message-----
> >Here are the connect strings I have tried:

> >1.
> >mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
> >Source=c:\Test.Mdb;Password='pwd'"

> >Error: Could not find installable ISAM

> >2.
> >mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
> >Source=c:\Test.Mdb;pwd='pwd'"

> >Error: Could not find installable ISAM

> >3.
> >mdb.ConnectionString = "Microsoft.Jet.OLEDB.4.0;Data
> >Source=c:\Test.Mdb;Jet OLEDB:Database Password='pwd'"

> >Error: Could not find installable ISAM

> >Help,
> >ThomasLL
> >.

Fri, 02 Sep 2005 18:39:29 GMT