Anyone know why I might be getting the following error on one machine and not another, Error: The Microsoft Jet database engine cannot open the file 'C:\PowerControl.mdb'. It is already opened exclusively by another user, or you need permission to view its
data. I know I am missing something fairly obvious here. Thanks in advance, Dan
The ASPNET user needs to have read/write/delete access to the folder where the MDB file exists. The ASPNET user needs to create and delete an LDB file, required by access for file sharing.
Actually, the ASPNet users only needs to be able to create the .ldb file. It then becomes the Owner of the file, and the Creator/Owner user should have full control over all files/folders, so it'll be able to delete the .ldb file. ASPNet: RXW (read, execute,
write) Creator/Owner: Full Control Cheers Ken
I did exactly this on a new WinServer2003 with II6+ASP.NET1.1. Doesn't help. Still same error. What else is required ? By the way: * It is a deployment env. No VB.net no MS Access installed. * the user is "IIS_WPG". It was created by IIS. Do ASP.NET need another
user ? BR, PC
Unless you modified the security settings, the user that is important is NOT IIS_WPG, but rather ASPNET. IIS users are normally IUSR_ in any event. If ASP.NET is intalled, there will be a user named ASPNET, and that is the user that needs the authority.
There is no user name anyway close to "ASPNET" on the WinServer2003. Though ASP.Net1.1 is installed, as it is able to give me the exception error page discussed hereabove. If I got it right: under my WinXP there is an ASP.NET engine called aspnet_wp that runs
my app. On WinServer2003 there is no such process. IIS tells me that an ISAPI web extention called "aspnet_isapi.dll" handles ASP.NET. That's why I supposed that IIS_WP was the correct user. Any clue ?
Never mind. Domain controllers in ASP.NET 1.1 are different. From my underatanding, the user in that case is IWAM_. I have not used ASP.NET 1.1 on a domain controller...
bookhockeymi...
Member
10 Points
2 Posts
Permission , MS ACCESS, should be simple
Sep 03, 2003 11:06 PM|LINK
douglas.reil...
All-Star
23315 Points
4647 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 01:34 AM|LINK
Programming Microsoft Web Forms
My Blog
Ken Schaefer
Participant
2000 Points
400 Posts
ASPInsiders
MVP
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 07:48 AM|LINK
mueslilux
Member
210 Points
42 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 02:25 PM|LINK
douglas.reil...
All-Star
23315 Points
4647 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 02:43 PM|LINK
Programming Microsoft Web Forms
My Blog
mueslilux
Member
210 Points
42 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 03:20 PM|LINK
douglas.reil...
All-Star
23315 Points
4647 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 04:05 PM|LINK
Programming Microsoft Web Forms
My Blog
mueslilux
Member
210 Points
42 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 04:09 PM|LINK
mueslilux
Member
210 Points
42 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 04:17 PM|LINK
douglas.reil...
All-Star
23315 Points
4647 Posts
Re: Permission , MS ACCESS, should be simple
Sep 04, 2003 05:03 PM|LINK
Programming Microsoft Web Forms
My Blog