IIS 7.0, Access 2007 and ASP.NET 2.0

I don’t get a chance to write webpage code very often, but in my early days of doing samples, it was common to use an Access database.  Access 2007 is the latest version available.  The drivers weren’t installed on my Windows Server 2008 server when I was trying to run an example.  I got the following error.

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

A quick search found the add-on, the link is listed below.  I don’t recommend using Access for medium or higher volume applications, SQL Server or another database is appropriate.  This was a fun exercise and I wanted to share my experience.  Hope this helps.

2007 Office System Driver: Data Connectivity Components

My sample

Download the code

Sample Code
<%@ Page Language=”VB” AutoEventWireup=”false” CodeFile=”authors.aspx.vb” Inherits=”_IISLogscom” %>

<!DOCTYPE html PUBLIC “-//W3C//D
TD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd“>

<html xmlns=”http://www.w3.org/1999/xhtml“>
<head runat=”server”>
    <title>Untitled Page</title>
    <form id=”form1″ runat=”server”>

                    AllowSorting=”True” AutoGenerateColumns=”False” DataKeyNames=”ID”
                                    ReadOnly=”True” SortExpression=”ID” />
                                    SortExpression=”Field1″ />
                                    SortExpression=”Field2″ />
                                    SortExpression=”Field3″ />
            SelectCommand=”SELECT [ID], [Field1], [Field2], [Field3] FROM [Authors]”>



Code Behind
Partial Class _IISLogscom
    Inherits System.Web.UI.Page

End Class

Web.config file
<?xml version=”1.0″?>
        <add name=”ConnectionString” connectionString=”Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot;/App_Data/authors.accdb&quot;” providerName=”System.Data.OleDb” />


Steve Schofield
Microsoft MVP – IIS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: