Connect to DB on Web Site

[jimt]

Unfortunately my VBA help is hosed and I have another newsgroup posting for
that so until I can do some of my own help...

I'm using Access 2000 & FP 2000 and have created a web site that contains a
subset of the tables in the local Access DB. The web site DB is a read only
use. I want to create a form w/module to connect to the web DB to clear the
tables and refresh the data from the local (master) DB.

What is the connect statement, in particuliar the datasource parm. I have
seen a lot of examples for locally stored DB (ie. "C:\") but none for a web
server based DB.

Thanks
Jim T.

 

[Douglas J. Steele]

Access does not recognize the http: nor ftp: protocols.