|
Home > Archive > MS Access and Internet > April 2005 > linked Access tables and asp files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
linked Access tables and asp files
|
|
|
| Hello,
I've inherited the maintenance of our intranet sites, which use several
Access databases and .asp pages. Many of the databases use the same tables,
and currently keep separate copies of the tables, instead of linking them to
one database.
When I attempted to do this, I got an error:
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the file
'\\binbosiis002\orgs
\dm2\data\product.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.
"product.mdb" is the main database that stores the tables. I don't think
this is a permissions problem, as I've checked Microsoft help files and
permissions seem to be there.
I'm really new to the whole asp thing, but does this have something to do
with "include" files. The web page where I get this error has an include file
to the database that has the queries I need and the tables are linked to the
product.mdb table.
Can you tell me what I need to do to make this work?
--
Marc
| |
| Douglas J. Steele 2005-04-27, 8:26 pm |
| Exactly what permissions did you check? ASP code usually runs in the
security context of IUSR_<machinename> (replace <machinename> with the
appropriate name). That's the ID that requires Change access (Read, Write,
eXecute and Delete) on the folder where the MDB file exists.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Marc" <Marc@discussions.microsoft.com> wrote in message
news:66402B8F-494A-4BBA-B7AC- 785C243CD617@microso
ft.com...
> Hello,
>
> I've inherited the maintenance of our intranet sites, which use several
> Access databases and .asp pages. Many of the databases use the same
> tables,
> and currently keep separate copies of the tables, instead of linking them
> to
> one database.
>
> When I attempted to do this, I got an error:
>
> Microsoft JET Database Engine error '80004005'
> The Microsoft Jet database engine cannot open the file
> '\\binbosiis002\orgs
\dm2\data\product.mdb'. It is already opened
> exclusively
> by another user, or you need permission to view its data.
>
> "product.mdb" is the main database that stores the tables. I don't think
> this is a permissions problem, as I've checked Microsoft help files and
> permissions seem to be there.
>
> I'm really new to the whole asp thing, but does this have something to do
> with "include" files. The web page where I get this error has an include
> file
> to the database that has the queries I need and the tables are linked to
> the
> product.mdb table.
>
> Can you tell me what I need to do to make this work?
>
> --
> Marc
| |
|
| Hi Doug,
Maybe I'm not understanding the permissions clearly. Here is what I see when
I check in the security tab of properties on the directory that contains my
files:
Administrators (Network name\Administrators)
Everyone
SYSTEM
They all have all of the boxes checked under "Allow". I don't have anything
called IUSR. Also, I don't have permission to add any names, I guess I'd have
to go to the IT department.
I don't understand why it works if the tables are not linked, but then
doesn't when they are linked.
Sorry about my igorance on this.
Thanks,
Marc
"Douglas J. Steele" wrote:
> Exactly what permissions did you check? ASP code usually runs in the
> security context of IUSR_<machinename> (replace <machinename> with the
> appropriate name). That's the ID that requires Change access (Read, Write,
> eXecute and Delete) on the folder where the MDB file exists.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Marc" <Marc@discussions.microsoft.com> wrote in message
> news:66402B8F-494A-4BBA-B7AC- 785C243CD617@microso
ft.com...
>
>
>
|
|
|
|
|