|
 |
asp_databases thread: Microsoft JET Database Engine (0x80004005)
Message #1 by adrian.stoin@w... on Tue, 29 May 2001 21:26:06
|
|
I receive this error when i try to get data from a different machine:
"Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'\\jh_gbo_b008\state\timesheet\timesheet.mdb'. It is already
opened exclusively by another user, or you need permission
to view its data."
I searched various forums regarding this, but I couldn't figure it out
what i have to change in my server settings (I understand is a permission
issue). Everything works fine when I am accesing the asp-s from my machine
(running PWS), and I also get data from a SQL Server 6.5 database.
Any advice greatly appreciated
Adrian
Message #2 by Hal Levy <hal.levy@s...> on Wed, 30 May 2001 10:09:17 -0400
|
|
Does someone else have the database open in Access? That will cause
this.
Did you give permissions to the IUSER account on the remote machine?
That's
the one that needs it.
Hal Levy
StarMedia Network, Inc.
Intranet Development Manager
-----Original Message-----
From: adrian.stoin@w... [mailto:adrian.stoin@w...]
Sent: Tuesday, May 29, 2001 5:26 PM
To: ASP Databases
Subject: [asp_databases] Microsoft JET Database Engine (0x80004005)
I receive this error when i try to get data from a different machine:
"Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'\\jh_gbo_b008\state\timesheet\timesheet.mdb'. It is already
opened exclusively by another user, or you need permission
to view its data."
I searched various forums regarding this, but I couldn't figure it out
what i have to change in my server settings (I understand is a
permission
issue). Everything works fine when I am accesing the asp-s from my
machine
(running PWS), and I also get data from a SQL Server 6.5 database.
Any advice greatly appreciated
Adrian
Message #3 by "Tomm Matthis" <matthis@b...> on Wed, 30 May 2001 10:54:29 -0400
|
|
Make sure the directory/folder where the .MDB resides has
read/write/create access for the IUSR_XXX account.... the reason is that
the lock file (.LDB) needs to be created/deleted as users open/close the
.MDB file.
-- Tomm
> -----Original Message-----
> From: Hal Levy [mailto:hal.levy@s...]
> Sent: Wednesday, May 30, 2001 10:09 AM
> To: ASP Databases
> Subject: [asp_databases] RE: Microsoft JET Database Engine
(0x80004005)
>
>
> Does someone else have the database open in Access? That will cause
this.
>
> Did you give permissions to the IUSER account on the remote
> machine? That's
> the one that needs it.
>
>
>
> Hal Levy
> StarMedia Network, Inc.
> Intranet Development Manager
>
> -----Original Message-----
> From: adrian.stoin@w... [mailto:adrian.stoin@w...]
> Sent: Tuesday, May 29, 2001 5:26 PM
> To: ASP Databases
> Subject: [asp_databases] Microsoft JET Database Engine (0x80004005)
>
>
> I receive this error when i try to get data from a different machine:
>
>
> "Microsoft JET Database Engine (0x80004005)
> The Microsoft Jet database engine cannot open the file
> '\\jh_gbo_b008\state\timesheet\timesheet.mdb'. It is already
> opened exclusively by another user, or you need permission
> to view its data."
>
> I searched various forums regarding this, but I couldn't figure it out
> what i have to change in my server settings (I understand is a
permission
> issue). Everything works fine when I am accesing the asp-s from
> my machine
> (running PWS), and I also get data from a SQL Server 6.5 database.
>
> Any advice greatly appreciated
>
> Adrian
Message #4 by adrian.stoin@w... on Wed, 30 May 2001 17:28:37
|
|
Thanks for advice
To become more interesting I have an asp which works fine with this
strings:
connStringEAG="PROVIDER=Microsoft.Jet.OLEDB.3.51;DATA SOURCE=\\jh_gbo_b008
\state\timesheet\timesheet.mdb;Jet OLEDB:Database password=pasat12;admin"
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.open sqlUsers ,connStringEAG,adOpenStatic
which is accessing the database from the server but the next one gives me
the error...
I'm stunned ...
I have an account -"Everyone" which has full rights on that folder where
the database resides on the server. I tried to add IUSER_SOI_DB_ADMIN
(IUSER_machine) but It wasn't in the list of users. If you don't mind can
you give me more details ?
Thanks in advance
> Make sure the directory/folder where the .MDB resides has
> read/write/create access for the IUSR_XXX account.... the reason is that
> the lock file (.LDB) needs to be created/deleted as users open/close the
> .MDB file.
>
> -- Tomm
>
> > -----Original Message-----
> > From: Hal Levy [mailto:hal.levy@s...]
> > Sent: Wednesday, May 30, 2001 10:09 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: Microsoft JET Database Engine
> (0x80004005)
> >
> >
> > Does someone else have the database open in Access? That will cause
> this.
> >
> > Did you give permissions to the IUSER account on the remote
> > machine? That's
> > the one that needs it.
> >
> >
> >
> > Hal Levy
> > StarMedia Network, Inc.
> > Intranet Development Manager
> >
> > -----Original Message-----
> > From: adrian.stoin@w... [mailto:adrian.stoin@w...]
> > Sent: Tuesday, May 29, 2001 5:26 PM
> > To: ASP Databases
> > Subject: [asp_databases] Microsoft JET Database Engine (0x80004005)
> >
> >
> > I receive this error when i try to get data from a different machine:
> >
> >
> > "Microsoft JET Database Engine (0x80004005)
> > The Microsoft Jet database engine cannot open the file
> > '\\jh_gbo_b008\state\timesheet\timesheet.mdb'. It is already
> > opened exclusively by another user, or you need permission
> > to view its data."
> >
> > I searched various forums regarding this, but I couldn't figure it out
>
> > what i have to change in my server settings (I understand is a
> permission
> > issue). Everything works fine when I am accesing the asp-s from
> > my machine
> > (running PWS), and I also get data from a SQL Server 6.5 database.
> >
> > Any advice greatly appreciated
> >
> > Adrian
|
|
|
View Cart
