First, you would connect using ODBC. Second, the MDB does not need to be on the web server. It only needs to be where your VFP code can find it, and it definitely should not be shared on the Web Server. Databases, tables, templates, your WC app and its associated files, etc., are not shared with respect to web access.
Your WC process PRG file should handle connecting to the MDB, querying the data which returns a cursor, then creating the HTML output using the appropriate WC method calls.
>Hi guy's
>
>Could somebody please assist me in the following:
>
>I have a Access database situated on a Web Server,my problem is how do I connect to it via VFP? What would be the proper procedure be in connecting to the specified database?Must the database be shared on the Web Server?
>
>Help will be highly appreciated.
>
>Colin Smith
Mark McCasland
Midlothian, TX USA