I get this error when trying to access a .mdb file from a networked drive:



The Microsoft Jet database engine cannot open the file 'g:\file.mdb'. It 

is already opened exclusively by another user, or you need permission to 

view its data. 



Microsoft Support site suggests that I need to do one of the followings:



- Clear "Allow IIS to control password" in the site's property in IIS

- Set read, write etc. permission in file.mdb's property and its folder 

property.



ASPalliance.com site suggests that I need to use OLE DB.



I have tried one or all of solutions above but still am getting the same 

error. 

I'm building and testing my Web site with Win2K Server and IIS5. I'm 

testing the connection with both DSN and DSnless connections. Both work 

when the file is local.



If I use the exact same file.mdb in my local drive C where the site dir 

is, I don't get any error. The site works properly. 



If I move file.mdb to a mapped network drive, i.e. g:/file.mdb, I get the 

error. 



After following the suggestion of Microsoft above to set permission on the 

file to my NT username, I now have Full Control over this file, its folder 

and its directory. 



I also cleared out the check box in site's property in the IIS as 

suggested. (IUSR_computerName)



Then I also set permission of the file, its folder and its dir to the 

IUSR_computerName, as suggested from Microsoft site. 



Thus, either my NT username or IIS name IUSR_computerName have Full 

Control over the file. 



Is there anything else I need to do? Did I do anything wrong? What else do 

I need to set in the site's property in IIS?



Pls help. 



Thanks 

qto

This may sound too simplistic.. but before you try to use the database..

open up your Windows explorer and make sure there is no red X over the

mapped drive. If there is..access the drive by clicking on it, this will

"renew" the connection via authentication...then try the ASP pages as you

normally would.

Good luck

Jim

----- Original Message -----

From: "Quy To" <qto@d...>

To: "Access ASP" <access_asp@p...>

Sent: Monday, September 24, 2001 10:37 PM

Subject: [access_asp] Access Permission





> I get this error when trying to access a .mdb file from a networked drive:

>

> The Microsoft Jet database engine cannot open the file 'g:\file.mdb'. It

> is already opened exclusively by another user, or you need permission to

> view its data.

>

> Microsoft Support site suggests that I need to do one of the followings:

>

> - Clear "Allow IIS to control password" in the site's property in IIS

> - Set read, write etc. permission in file.mdb's property and its folder

> property.

>

> ASPalliance.com site suggests that I need to use OLE DB.

>

> I have tried one or all of solutions above but still am getting the same

> error.

> I'm building and testing my Web site with Win2K Server and IIS5. I'm

> testing the connection with both DSN and DSnless connections. Both work

> when the file is local.

>

> If I use the exact same file.mdb in my local drive C where the site dir

> is, I don't get any error. The site works properly.

>

> If I move file.mdb to a mapped network drive, i.e. g:/file.mdb, I get the

> error.

>

> After following the suggestion of Microsoft above to set permission on the

> file to my NT username, I now have Full Control over this file, its folder

> and its directory.

>

> I also cleared out the check box in site's property in the IIS as

> suggested. (IUSR_computerName)

>

> Then I also set permission of the file, its folder and its dir to the

> IUSR_computerName, as suggested from Microsoft site.

>

> Thus, either my NT username or IIS name IUSR_computerName have Full

> Control over the file.

>

> Is there anything else I need to do? Did I do anything wrong? What else do

> I need to set in the site's property in IIS?

>

> Pls help.

>

> Thanks

> qto

>

Hi,

In MS-Access, go to Tools menu, click options and you will find  a menu..

select advanced tab in that and change the record lock option to No Locks.



Syed

I am not sure that this is your problem, but MAYBE:



Try using the actual physical drive and directory on the server -- not a

network drive letter. Log in to the server and find the location of the

file. The g: drive is only valid locally and is not available to the ASP

file running on the server.









----- Original Message -----

From: "Quy To" <qto@d...>

To: "Access ASP" <access_asp@p...>

Sent: Monday, September 24, 2001 10:37 PM

Subject: [access_asp] Access Permission





> I get this error when trying to access a .mdb file from a networked drive:

>

> The Microsoft Jet database engine cannot open the file 'g:\file.mdb'. It

> is already opened exclusively by another user, or you need permission to

> view its data.

>

> Microsoft Support site suggests that I need to do one of the followings:

>

> - Clear "Allow IIS to control password" in the site's property in IIS

> - Set read, write etc. permission in file.mdb's property and its folder

> property.

>

> ASPalliance.com site suggests that I need to use OLE DB.

>

> I have tried one or all of solutions above but still am getting the same

> error.

> I'm building and testing my Web site with Win2K Server and IIS5. I'm

> testing the connection with both DSN and DSnless connections. Both work

> when the file is local.

>

> If I use the exact same file.mdb in my local drive C where the site dir

> is, I don't get any error. The site works properly.

>

> If I move file.mdb to a mapped network drive, i.e. g:/file.mdb, I get the

> error.

>

> After following the suggestion of Microsoft above to set permission on the

> file to my NT username, I now have Full Control over this file, its folder

> and its directory.

>

> I also cleared out the check box in site's property in the IIS as

> suggested. (IUSR_computerName)

>

> Then I also set permission of the file, its folder and its dir to the

> IUSR_computerName, as suggested from Microsoft site.

>

> Thus, either my NT username or IIS name IUSR_computerName have Full

> Control over the file.

>

> Is there anything else I need to do? Did I do anything wrong? What else do

> I need to set in the site's property in IIS?

>

> Pls help.

>

> Thanks

> qto

>

It has always been "No Locks."



Thanks, qto



----- Original Message -----

From: <credfirst@c...>

To: "Access ASP" <access_asp@p...>

Sent: Monday, September 24, 2001 11:00 PM

Subject: [access_asp] Re: Access Permission





>

> Hi,

> In MS-Access, go to Tools menu, click options and you will find  a menu..

> select advanced tab in that and change the record lock option to No Locks.

>

> Syed