Access linked tables and asp pages

[DenverMarc]

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?

Thanks,

Marc

 

[steven290]

no the iusr_Machine stands for the internet quest account (don't quote me) so if you set the folder(with all subs inherit) with full permissions for the internet guest account anyone can see it

 

[steven290]

look

http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=290

http://rtfm.atrax.co.uk/infinitemonkeys/articles/asp/921a.asp

 

[DenverMarc]

Okay, that makes sense. I'll have to talk to network administrator.

Thanks for everyone's help.

Marc

 

[steven290]

glad it worked out for you