Connection String problem

[William Gower]

I have set up a Setting in my Web.Config file. In my data class, I call

strConnectionString = Configuration.AppSettings("MyConnectionString"). I
know that I need to do something with the Server.MapPath method but how do I
do that in my data access layer class?

<appSettings>

<add key="MyConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;User
ID=;Password=;Data Source=\database\union.mdb"></add>

</appSettings>

<

 

[Karl]

Just put the full path to the mdb file in the web.config under Data Source..

<add key="MyConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;User
ID=;Password=;Data Source=c:\inetpub\wwwroot\database\union.mdb"></add>

Karl