connection

I know many people ask this but I am having trouble connecting to my remote access db on my hosting server.

I have a site made on my local maching with connections to a local DB, I now want to upload the site to my web host, but am having troubles changing the connection string and making it work.

My site is in: C:\Inetpub\wwwroot\sitename

and my db is in C:\Inetpub\database

my curent connection string is
"Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\database\Record_Webtest.mdb"

all is working great on my local testing server. But how do i know how to connect to the remote location and what should the path look like?? I don tknow much about all this, I have been learning by trial and error, but at this last stage have become slightly stuck.

I have tried many connection strings off the web etc but none have worked, I am  using Dreamweaver MX if that helps.

I know it should be a simple thing to do, but I'm having trouble.

thanks in advance, if i need to give any more info please let me know

mark

OK fantastic mate,

I now have my path form my webhost.

I have subsituted that path and tried different variations to make it work but I keep getting ODBC errors in dreamweaver when I test the connection. Can anyone please suggest a connection string I can use, as this is my last hurdle on creating my site and is really winding me up!

Also, when I am previewing and amending site design etc, do I have to always connect to my remote DB?

Sorry if these questions sound stupid, but I have been riding on trial and error throught the whole site design process, and have done pretty well up to now........

many thanks
mark

ainsworth14 wrote: Also, when I am previewing and amending site design etc, do I have to always connect to my remote DB?

DBQ=" & Server.MapPath("data/database.mdb") & ";

IMHO this is most professional solution.