From an earlier reply: easy way to set up remote MDB connectivity. Effectively, it lets you send a URL to a remote user - which they can bookmark - and when they plug the URL into their browsers, they can cut CSV, tab-delimited or XML versions of the database data.
So it easily allows a user to cut their own data from an MDB hosted an another PC (say, to import it into their own Access database or XLS spreadsheet).
The URL can consist of a SELECT statement and refers to the host that controls the MDB. Thus, you could have it represent Access data, SQL Server 2000 and/or other connected sources in the MDB. Details/free download here, not time-limited:
You can require authentication, allow updates, etc. if you wish.
So it easily allows a user to cut their own data from an MDB hosted an another PC (say, to import it into their own Access database or XLS spreadsheet).
The URL can consist of a SELECT statement and refers to the host that controls the MDB. Thus, you could have it represent Access data, SQL Server 2000 and/or other connected sources in the MDB. Details/free download here, not time-limited:
You can require authentication, allow updates, etc. if you wish.