Configuring Microsoft IIS 7 for Microsoft Access Applications

There are two ways to configure an application with Microsoft Access database.

Option #1:  Copy the Microsoft Access database file to your application’s folder

Update the “Data Source” attribute in your application’s Web.config file, e.g.:

<add key="DatabaseSouthwind.mdb1" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Southwind.mdb;Jet OLEDB:Database Locking Mode=1;Mode=16" />

Be sure the application pool your application is using is enabled for 32-bit operation, as discussed below.

Option #2:  When the Microsoft Access database file is in a folder other than the application folder

Step 1:  Select 'Default Web Site' node and double-click 'Default Document' in the IIS section.  Make sure 'Default.aspx' is added and its 'Entry Type' is 'Inherited'.

Step 2:  Place your application within an IIS Application Pool that has 'Enable 32-Bit Applications’ set to ‘True'.

Step 2a:  Configure your application by selecting its Application node under its web site, usually is the 'Default Web Site':

Step 2b:  In the Actions pane, click 'Advanced Settings…', and determine which application pool your application is using (usually the 'DefaultAppPool').

Step 2c:  In Application Pools, select the application pool or the 'DefaultAppPool', click 'Advanced Settings' and set these options:

Option

Setting

Enable 32-Bit Applications

True

Managed Pipeline Mode

Integrated

Identity

NetworkService

Step 3:  The application sets a credential account which can access the specified physical path

Step 3a:  Select the Application node under its web site (usually is the 'Default Web Site').  In the Actions pane, click 'Basic Settings…' and in the 'Edit Application' dialog, click 'Connect as…' button.

Step 3b:  In the 'Connect As' dialog box, select 'Specific user' and click the ‘Set…’ button.

Step 3c:  In the 'Set Credentials' dialog box, enter a user name and password.  This user account is a member of the Administrators group.

Step 3d:  In the 'Edit Application' dialog, click the 'Test Settings…' button and make sure the 'Authorization' is in green.

Step 3e:  Click the ‘Browse *:80 (http)’ link to run your application in a browser.

See Also

Configuring Microsoft IIS 7 for Microsoft Access Applications

Configuring Microsoft IIS on Microsoft Vista

Running as Administrator in Microsoft Vista

Installing Microsoft IIS on Microsoft Windows XP Professional

Installing Microsoft IIS on Windows Server 2003

Using Non-Standard Ports in Microsoft IIS

Application Pools in Microsoft IIS

Running Applications in 64-bit Mode