Web.Config Settings for Microsoft Access Databases

When deploying applications that use Microsoft Access databases, you may need to modify your application’s Web.config file to point to the database on the deployment machine.

The Web.Config file contains a line such as:

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

Note the Source= line in the above key.  You may need to change the Source= line to point to the Microsoft Access file located on the local machine.

Please note the following:

See Also

Web.config Configuration File