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

"Torsten Hannerfeldt" <Torsten
wrote ...

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/...orMicrosoftJet

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

Jamie.

--

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

"Torsten Hannerfeldt" <Torsten wrote in message ...
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