Best way to edit and deploy pages to remote host.

Hi All,

I wasnt sure whether to ask this in General or here.... sorry if this is the wrong forum.

When I make a site using an access database & asp pages In the DW I tend to do everything from the remote server.
I set the site up in my properties and test remotly etc and it all works out fine.

But what I find is remotely it seems to slow up my PC and DW hangs quite often when I try to close it down or change sites..

My problem is I have a connection string for my database and Locally the database is just in the root of the site so I used to use a Server.mapPath to get my connection..

But on the remote server My DB is in an outside Private directry and my connection string needs the full path to the DB.

What im finding is if I test locally and upload the connection string online chenges to the local connection string and I have to go and change it to get the proper paths on the server again, even if I choose not to upload dependant files this seems to happen.

Im wondering how you guys do this and if there is anything im missing in my set up and the best way to edit test and upload your files in DW.

Thanks again
Tag