Re: MS Access connection and web.config

[Ken Cox [Microsoft MVP]]

In your web.config file, add a key and the correct connection string as
shown below:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="connstring"
value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\thepath\accessdb.mdb;User ID=Admin;Password="
/>
</appSettings>
<system.web>
.....

In your codebehind file, read in the configuration setting:

Private Sub Page_Load _
(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim strConnection As String
strConnection = _
ConfigurationSettings.AppSettings("connstring")
Label1.Text = "The connection string is " & strConnection
End Sub

You'll have to adjust the Data Source path to suit the location of your
Access file.

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]
Toronto