data source - access db on the web

I need to update an Access database which is on the web. Could anyone show me an example of connectionString to ftp.
Thank you very much in advance

You probably will not be able to connect to the db remotely, you'll have to copy the mdb to your local computer, do what you need, and then upload the mdb back to the host (overwriting anything that happened in the db while you were working on it).

I'd recommend using MS SQL Server or MySQL that you can connect to from a remote computer.

I can speak with discouraging experience...
I looked extensively to find a way to connect from WITIN my MS ACCESS (any version upto 2002) and create or modify a database that was stored at another server USING FTP from within MS ACCESS. I also attempted to create a network Shortcut to the same server as "access help" hinted at...
Unfortunately, I discovered that MS ACCESS does not support remotely creating and accessing a Database on another server.
(IF there IS such a way I would GLADLY love to hear how it was done).

I CAN say... that the Only way I was able to use my LOCALLY created access database on another server was to close the Access program... then OPEN a FTP connection to my server and then COPY the database from the local folder and paste it into the folder that I wanted to use on the remote server... (as the previous poster alluded too)

There are ways to connect to the database from within the remote server side web pages... once you upload them via FTP

You will need your remote server administrator to grant you FTP access (usually) to the site so that you can upload and download your .mdb file(s) and web pages.
as well as the complete PATH of the folder ex... E:\Inetpub\wwwroot\NHUAL.com\NHUAL_DB\NHUAL.mdb
(this will be needed for later use... also... you may need your remote administrator to give you write/read access for subfolders as well as a DSN for the database)


You will need the URL or IP of that remote folder as well...

then simply do the following in Win XP
OPEN any desktop folder or create a new one ... and change the address to:

ftp://Your.URL.NET/

This will open a FTP window to your site...
then RIGHT CLICK inside that window... and choose LOGIN AS
you will need your user name and password.



I hope this helps...
HKP_MACK ( not an expert... barely able to figure this out)