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

www.able-consulting.com/ado_conn.htm
has the necessary connection string.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tim Morgan" <aviatortim@h...>
Subject: [access_asp] 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?!

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

Ken,
Thanks for the recommendation.  I believe the "standard security" 
connection string listed under "ole db provider for Microsoft Jet" is the 
connection string I'm looking for (http://www.able-
consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet).  However if I 
try it with a user id of "Admin" as the example shows I get this error:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing

If I try it with a use id of Tim Morgan (my Win2K login id) I get the 
error message:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.

I don't know if I'm using the wrong connection string or the wrong user 
id.  The connection string that works (without a password is) 
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
Data Source=C:\Inetpub\wwwroot\shuttle\Shuttle.mdb;"

so I though I would need the MS Jet OLEDB connection string.  Access does 
not ask for a user id when I log in, only a password, so I'm just guessing 
what the user id might be.

Tim

> www.able-consulting.com/ado_conn.htm
has the necessary connection string.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tim Morgan" <aviatortim@h...>
Subject: [access_asp] 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?!

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

I think you need to look inside Access after you have logged in to see what
you have for this particular database

There are various different security options:
a) set a password (in which case a password is set on the Admin account I
believe)
b) setup users/groups (in which case you're using standard security)
c) setup a workgroup file (in which case you need to use the workgroup
security connection string)

I'm a bit hazy on all these different options since I don't do much
development work with Access anymore. Looking in Access online Help will
probably tell you more about these different options.

Cheers
Ken

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


: Ken,
: Thanks for the recommendation.  I believe the "standard security"
: connection string listed under "ole db provider for Microsoft Jet" is the
: connection string I'm looking for (http://www.able-
: consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet).  However if I
: try it with a user id of "Admin" as the example shows I get this error:
: Microsoft JET Database Engine (0x80040E4D)
: Cannot start your application. The workgroup information file is missing
:
: If I try it with a use id of Tim Morgan (my Win2K login id) I get the
: error message:
: Microsoft JET Database Engine (0x80004005)
: Could not find installable ISAM.
:
: I don't know if I'm using the wrong connection string or the wrong user
: id.  The connection string that works (without a password is)
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: Data Source=C:\Inetpub\wwwroot\shuttle\Shuttle.mdb;"
:
: so I though I would need the MS Jet OLEDB connection string.  Access does
: not ask for a user id when I log in, only a password, so I'm just guessing
: what the user id might be.
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~