You can run the Web Manager on one machine and host the data on another machine. This requires that the appropriate permissions
be granted to IIS to access data across the network.
|
1. |
Place the access (.mdb) file on target network machine in a non-root (not C:/) folder. It is recommended that you create a folder on the root and place the database in this folder. |
|
2. |
On the web server, determine the Anonymous Access Account that IIS is using. This is usually of the form IUSR_MACHINENAME.
|
|
3. |
Share the target folder to the Anonymous Access Account. The minimum permission is Change permission. |
|
4. |
Set permissions on target folder for the Anonymous Access Account. The minimum permission is Change permission. |
|
5. |
Create an ODBC data source pointing across the network to the Access database. |
To test the permissions, log on to the Web Server using the Anonymous Access Account. If you are not able to access the database
through this account, then IIS cannot either.
Determining the Anonymous Access Account
IIS uses an NT account to access all network resources. A default account is created when IIS is installed.
|
1. |
In IIS, open the Properties for the web site.
|
|
2. |
Click the Directory Security tab.
|
|
3. |
In the Anonymous Access section, click Edit. The Authentication Methods window appears.
|
|
4. |
Ensure the Allow Anonymous Access check box is selected and click Edit. The Anonymous User Account window appears.
|
|
5. |
The username indicates the NT user account granted to IIS.
|