Opening an Access DB with password using DAO

[Catrina]

I have an app that is usin DAO (I am Used to ADO), and I'm having trouble with opening the passworded database.
I am getting the message Not a Valid Password when I know it is. Here is my code:

Set db = DBEngine(0).OpenDatabase("pdp.mdb", , , "Jet OLEDB;password=mypass&quot

What am I doing wrong? Thanks in advance

Catrina

 

[Ologhai]

Hi Catrina,

i use ADO to open Access Database, hope this will help you

Set gConDyn5 = New ADODB.Connection
Set gRecDyn5_Client = New ADODB.Recordset
wSQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='yourMDB.mdb';Mode=Read;Persist Security
Info=False;Jet OLEDBatabase Password=/*"
gConDyn5.Open wSQL
_____________________________
Hugues Gauthier P.A,DEC
Programmeur Analyste
Progitech GS Inc.

http://www.progitech.com/

hugues.gauthier@progitech.com
hugues_gauthier@hotmail.com
Tel. : (418) 698-4383 #19
Fax.: (418) 698-8633
---------------------
ICQ: 2151800