I want to publish my first website using Visual Web Developer 2010 Express.
I have a connection string (shown below) in my web.config file.  The database 
is MS Access 2007.

Assume I have registered the name ABC.com and I want to publish to it.  I haven't
chosen a host yet.  The Data Source must be changed but I don't know what to
change it to so it will work on the web.

Data Source=C:\OurDocuments\Visual Studio 2010\Projects\SunriseFarms\SunriseFarms\App_Data\SunriseFarms.accdb

Can anyone tell me what to change the Data Source to?

Thank you.

<?xml version="1.0"?>
    <add name="SFConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\OurDocuments\Visual Studio 2010\Projects\SunriseFarms\SunriseFarms\App_Data\SunriseFarms.accdb;Persist Security Info=False;" />
4 Years
Discussion Span
Last Post by JorgeM

Once you choose a host and are familiar with the folder/file structure, you can just update your local copy of web.config file with the correct path and upload it to your provider.

Your provider can give you that path.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.