Walkthrough: Creating a Web Page to Display Access Database Data

Walkthrough: Creating a Web Page to Display Access Database Data

I've started the above walkthrough. However, near the beginning it gives the following instructions

To set permissions in the App_Data folder
In Windows Explorer, move to the root folder for the Web site.

The default location for your new Web site is c:\inetpub\wwwroot\AccessSample.

If the App_Data folder does not already exist, create one.

By default, Visual Web Developer creates the folder when you create a new Web site.

Right-click the App_Data folder, click Properties, and then click the Security tab.

My problem is that there is no security tab. The other tabs - general, sharing,web sharing and customize are there.

By the way, the folder is in the iis folder, and my iis is correctly configured.

dennist685

dennist685 wrote:

My problem is that there is no security tab. The other tabs - general, sharing,web sharing and customize are there

Sounds like you are not running in NTFS file mode (which is set during the OS installation).. i'm not sure how you set the mode if you are running FAT32
Nope, its ntfs, not fat32.
dennist685
hello.
well, since you're creating your app inside the wwwroot folder then you shouldn't have to do anything else since the asp.net user should have privileges in that i'd go with the following steps...

Luis wrote:
hello.
well, since you're creating your app inside the wwwroot folder then you shouldn't have to do anything else since the asp.net user should have privileges in that i'd go with the following steps...

What are the following steps?
hello.
well, i really don't know since i haven't lokoed at the walkthrough. just keep following the steps. you'll just have to worry about the security issues if you're unable to access the database. if that happens, then you'll have to change the current definitions on the security tab of the folder and db files.

Luis,
Thank you for your time. I've discovered its a little bit more complicated than that. I tried the same walkthrough in c:\vs2005web\AccessSample and it worked fine.
It has something to do with IIS, possibly.
Any ideas?
dennist685
Luis,
Now something new happened. I added generate edit,insert, delete to the version in the inetpub version.
However, it opened up in the asp.net development server instead of IIS, and worked fine.
Should I continue this aspect in this thread or start a new thread?
dennist685
hello.
well, this is really a security problem. when you use the internalserver, you're using your credentials instead of the asp.net accountthat is used by IIS (ie, if you're running as admin, then the internalserver will perform all the operations with the credentials of youraccount). so, you'll have to access the properties of the file and giveit read/write access for your asp.net user (if you're using asp.netthen you should use the aspnet account; if you're in 2003 it depends onyour pool - by default, IIS uses the network account). what i reallydon't understand is why you can't access the security tab when you'rein the file properties dialog (this should only happen when you'reusing FAT; however, you say you're using NTFS...)...