Open password protected database

[Guest]

Hello!
How do I open a connection to a password protected access database? I'm not
using user level protection, only the database itself is protected.

Public cn As ADODB.Connection

Public Sub ConnectToDatabase()
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "
& _
strDBPath & "db1.mdb;"

cn.Open
End Sub

 

[Jamie Collins]

How do I open a connection to a password protected access database? I'm not
using user level protection, only the database itself is protected.

Try this connection string resource:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

Look for the section 'If MDB has a database password'.

Jamie.

--

 

[timatey]

Hi,
read this article about Access database passwords
http://lastbit.com/access-article.asp and try Access Password recovery
http://lastbit.com/access