yes this is a webform, that's why I have a web.config
I'm not using server.mappath to find web.config, I'm trying to change the connection string. The static connection string "C:/.../mytable.mdb" won't work because the table is now located in the webhost and I can't seem to use the url "www.sitename.com/tables/mytable.mdb" as part of the connection string.
I have resolved this issue (a bit) by placing the Server.MapPath call within the pages...
That was going to be my next suggestion with the caveat that you should check to ensure you site is not being hosted in a web farm/garden (which would obviously cause serious problems with any file references).
The whole point of a .config file is that it probably changes from machine to machine. I have a hardcoded path in my web.config on my test machine. I have a different hardcoded path in my web.config on my production machine. When I move files to production, I just don't change the config.