Password problem

Hey,

I've been using ADO for a few years now and now I need to simply open
an access DB using DAO3.6 which has is password protected.

set dbtemp = opendatabase("MyDB.MDB",False,False," ;pwd=mypass")

I get an error about "cannot find...ISAM" something, something...
If I remove the second False I get "Invalid password"

I don't want to work with workspaces nor ODBC I simply want to open the
password protected Access2000 DB using DAO3.6.

Thanx in advance.
David

On Mon, 4 Oct 2004 09:21:25 -0400, "David" <not.TakeThisOut@directemail.com> wrote:

¤ Hey,
¤
¤ I've been using ADO for a few years now and now I need to simply open
¤ an access DB using DAO3.6 which has is password protected.
¤
¤ set dbtemp = opendatabase("MyDB.MDB",False,False," ;pwd=mypass")
¤
¤ I get an error about "cannot find...ISAM" something, something...
¤ If I remove the second False I get "Invalid password"
¤
¤ I don't want to work with workspaces nor ODBC I simply want to open the
¤ password protected Access2000 DB using DAO3.6.
¤

I believe you need to specify the driver in the Connect string parameter

set dbtemp = opendatabase("MyDB.MDB",False,False,"MS Access;pwd=mypass")


Paul ~~~ pclement.TakeThisOut@ameritech.net
Microsoft MVP (Visual Basic)