I am having a bit of an issue with connecting to an Access database across servers.
The Access database is on a mapped drive (G
from the IIS server. The path would be G:\db\database.mdb
When i hit the aspx page, as soon as i click the link that would run the sub to hit the database, i get the following error "The Microsoft Jet database engine cannot open the file 'G:\db\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data."
I have full rights to the server i'm trying to connect to and the Anonymous Inet User Account IUSR_IS800 has rights as well. Am i missing some rights that have to be given to the IUSR account? Does IIS hit Access databases differently than SQL Databases?
Any and all help is greatly appreciated. Unfortunately, this is the only think left holding up putting the close on this project.
Thank You,
dc~
The Access database is on a mapped drive (G
from the IIS server. The path would be G:\db\database.mdbWhen i hit the aspx page, as soon as i click the link that would run the sub to hit the database, i get the following error "The Microsoft Jet database engine cannot open the file 'G:\db\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data."
I have full rights to the server i'm trying to connect to and the Anonymous Inet User Account IUSR_IS800 has rights as well. Am i missing some rights that have to be given to the IUSR account? Does IIS hit Access databases differently than SQL Databases?
Any and all help is greatly appreciated. Unfortunately, this is the only think left holding up putting the close on this project.
Thank You,
dc~