I wrote a working connection to an Access database but I cannot figure out 
how to ad a password (and still successfully connect!).  The working 
connection string is:
objConn.Open strConnect    

According to the book, I should be able to append a user name and password 
such as:
objConn.open strConnect, "userid", "password"

I went to Access/Tools/Security/Set Database Password to add a password.  
Then I appended my user name and password to the connection string but get 
the following error:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing 

Will someone knowledgeable on this issue please help?!

Tim

http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet

(under the heading "If MDB has a database password")

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tim Morgan" <eastcoastpilot@h...>
Subject: [asp_database_setup] problem passing password to Access via
connection string


: I wrote a working connection to an Access database but I cannot figure out
: how to ad a password (and still successfully connect!).  The working
: connection string is:
: objConn.Open strConnect
:
: According to the book, I should be able to append a user name and password
: such as:
: objConn.open strConnect, "userid", "password"
:
: I went to Access/Tools/Security/Set Database Password to add a password.
: Then I appended my user name and password to the connection string but get
: the following error:
: Microsoft JET Database Engine (0x80040E4D)
: Cannot start your application. The workgroup information file is missing
:
: Will someone knowledgeable on this issue please help?!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~