Hi.

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"?>
<configuration>
  <connectionStrings>
    <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;" />
  </connectionStrings>

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.