Ken,

Thanks for the feedback.  Your input on the various security options 
helped solve the problem.  I never did get it to work using the workgroup 
information file.  However, I was able to set a databse password and pass 
that with the connection string which was the main goal.

Tim

> 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.
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~