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
"William Gower" <w_*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

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>

<