Hi Bonnie,

Ok I put this in the web.config file

<add key="SWHT\Connection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/SWHT.mdb") />

I get the following errors:

Data Source="    Missing required white space
+                Character '+' hexidecimal value 0x2b is illegal in an XML name
("~/App_Data/SWHT.mdb")  Character '(' same as above
/ inside the path causes - Expecting '/>'

Clearly being an XML file causes the issues here, but what might be the proper syntax for getting this within an xml file?

>

>"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/App_Data/ASPNetDB.mdb")
>

>
>
>~~Bonnie
>
>
>
>
>>I am getting desperate. I have deployed this website 5 times last night trying to get a connection string to work for access. I can do it fine on my development machine because I use the full path to the file. On the web server I don't know what this is. If someone could help it would be greatly appreciated.
>>
>>I am placing my data file in App_Data under the root. How do I create a connections string that maps to that location?
>>
>>Tim