laura wrote:
>
> DSNNAME = "Provider=Microsoft.Jet.OLEDB.4.0; User
> ID=;Password=letmein; Data Source=" &
> server.mappath("\databases\users.mdb") & ";"
> This is the error message I get with Option (B):-
>
> Microsoft JET Database Engine error '80040e4d'
> Cannot start your application. The workgroup information file is
> missing or opened exclusively by another user.
> /check_user.asp, line 42
>
>
> Could it be that the password is not working? It does work in Option
> (A), but not in Option (B). The database has been password protected
> with password "letmein". What am I doing wrong?

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eOjiHjtXFHA.3184@TK2MSFTNGP15.phx.gbl...
> laura wrote:
>>
>> DSNNAME = "Provider=Microsoft.Jet.OLEDB.4.0; User
>> ID=;Password=letmein; Data Source=" &
>> server.mappath("\databases\users.mdb") & ";"
>> This is the error message I get with Option (B):-
>>
>> Microsoft JET Database Engine error '80040e4d'
>> Cannot start your application. The workgroup information file is
>> missing or opened exclusively by another user.
>> /check_user.asp, line 42
>>
>>
>> Could it be that the password is not working? It does work in Option
>> (A), but not in Option (B). The database has been password protected
>> with password "letmein". What am I doing wrong?
>
>
> Since your database is not using workgroup security, you should not be
> using a user name and password. It looks as if your database is
> password-secured (which is futile security at best). If so, your
> connection string should look like this (from www.carlprothman.net):
>
> DSNNAME = "Provider=Microsoft.Jet.OLEDB.4.0; Jet OLEDB:Database
> Password=letmein; Data
> Source=" & server.mappath("\databases\users.mdb") & ";"
>
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

"Steven Burn" <somewhere@in-time.invalid> wrote in message
news:eA5zactXFHA.2124@TK2MSFTNGP14.phx.gbl...

"laura" <replyto@group.com> wrote in message
news:eiT45WtXFHA.2420@TK2MSFTNGP12.phx.gbl...
> Not sure if this is the right place to ask..
>
> I have a computer with Windows 98 on which I have set it up as a Personal
> Web Server and I am running/testing a small Access database. I am working
> from my XP computer in the same room, connected by network cable.
>
> I am confused as to which connection I should be using. I have to admit,
> one
> works (A), but I've been advised that I really should be using the other
> (B).
>
> A) This works.
>
> DSNNAME = "Driver={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein;
> DBQ="
> & Server.MapPath("\databases\users.mdb")
>
> B) This does not work and this is what I believe I should be using:-
>
> DSNNAME = "Provider=Microsoft.Jet.OLEDB.4.0; User ID=;Password=letmein;
> Data
> Source=" & server.mappath("\databases\users.mdb") & ";"
>
> This is the error message I get with Option (B):-
>
> Microsoft JET Database Engine error '80040e4d'
> Cannot start your application. The workgroup information file is missing
> or
> opened exclusively by another user.
> /check_user.asp, line 42
>
>
> Could it be that the password is not working? It does work in Option (A),
> but not in Option (B). The database has been password protected with
> password "letmein". What am I doing wrong?
>
> thanks
> Laura TD
>
>

"laura" <replyto@group.com> wrote in message =
news:eIUToouXFHA.3864@TK2MSFTNGP10.phx.gbl...
> Hello Steven,
>=20
> Thanks for your reply. There was another from Bob Barrows also which =
cleared=20
> my "string" up so that it would work - as it turns out, it looks as if =
I=20
> needed to add "Jet OLEDB:Database " before the word "Password".
>=20
> This database will be on an intranet, not visible to the outside =
world, and=20
> I will ensure it is an area not accessible by all the staff. It's =
going to=20
> hold usernames and passwords for those members of staff allowed to =
access=20
> certain areas of the intranet. Not sure if it's the best method, but =
so far=20
> it's the only method I've worked out.
>=20
> Many thanks for pointing that out to me and for your assistance.
>=20
> Regards,
> Laura TD
>=20
>=20
> "Steven Burn" <somewhere@in-time.invalid> wrote in message=20
> news:eA5zactXFHA.2124@TK2MSFTNGP14.phx.gbl...
> Firstly, DO NOT stick the database in reach of the outside world =
(stick it=20
> above the web root).
>=20
> As for the connection, give this a try;
>=20
> objDB =3D "\database\users.mdb"
> DSNName =3D "PROVIDER=3DMicrosoft.Jet.OLEDB.4.0;DATA SOURCE=3D" +=20
> Server.MapPath(objDB) + ";Jet OLEDB:Database Password=3Dletmein;"
>=20
> --=20
> Regards
>=20
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>=20
> Keeping it FREE!
>=20
> "laura" <replyto@group.com> wrote in message=20
> news:eiT45WtXFHA.2420@TK2MSFTNGP12.phx.gbl...
> > Not sure if this is the right place to ask..
> >
> > I have a computer with Windows 98 on which I have set it up as a =
Personal
> > Web Server and I am running/testing a small Access database. I am =
working
> > from my XP computer in the same room, connected by network cable.
> >
> > I am confused as to which connection I should be using. I have to =
admit,=20
> > one
> > works (A), but I've been advised that I really should be using the =
other
> > (B).
> >
> > A) This works.
> >
> > DSNNAME =3D "Driver=3D{Microsoft Access Driver =
(*.mdb)};uid=3D;pwd=3Dletmein;=20
> > DBQ=3D"
> > & Server.MapPath("\databases\users.mdb")
> >
> > B) This does not work and this is what I believe I should be using:-
> >
> > DSNNAME =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0; User =
ID=3D;Password=3Dletmein;=20
> > Data
> > Source=3D" & server.mappath("\databases\users.mdb") & ";"
> >
> > This is the error message I get with Option (B):-
> >
> > Microsoft JET Database Engine error '80040e4d'
> > Cannot start your application. The workgroup information file is =
missing=20
> > or
> > opened exclusively by another user.
> > /check_user.asp, line 42
> >
> >
> > Could it be that the password is not working? It does work in Option =
(A),
> > but not in Option (B). The database has been password protected with
> > password "letmein". What am I doing wrong?
> >
> > thanks
> > Laura TD
> >
> >
>=20
>=20