dotnet academic: Hello

I am writing an ASP.NET application and accessing a MS-Access DB
I get the following erro
The Microsoft Jet database engine cannot open the file 'C:\My Folder\CI211 - C#\Final Project\Northwind_2.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

How can I resolve this problem

I heard that I should enable impersonation of my ASP.NET application. What is all that about

Regards

Paol

Paolo,

When you use an Access database within ASP .NET, two things are required.
First, the ASPNET user needs permission to read/write to the database
(assuming you are including insert, delete, or update ability. Second, the
ASPNET users needs to be able to create a file within the application folder
because Access create a new file to manage locking.

Please see:

http://www.asp.net/security.aspx?tabindex=0&tabid=1

for complete details.

bill burrows

[quoted text, click to view]
Folder\CI211 - C#\Final Project\Northwind_2.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.]
[quoted text, click to view]

Hello

I don't know if this matters, but I am using Windows XP on my toshiba laptop computer
When I select the wwwroot folder and right click the Properties from the contextual help......I get a slightly different dialog box from the one shown in the technical article.........

What now

Paolo,

If you are not seeing the Security tab, open the "Folder Options" control
panel, select the "View" tab, and uncheck the last option "Use simple file
sharing".

bill burrows

[quoted text, click to view]
contextual help......I get a slightly different dialog box from the one
shown in the technical article..........
[quoted text, click to view]