A
ame12
Guest
Easy, free way to set up remote DB connectivity - through a browser.
Effectively, it lets you create a URL (which you can send to a remote user and they can bookmark). When they plug the URL into their browsers, they can view CSV, tab-delimited or XML versions of the database data. They could then import it into their own Excel or Access data or otherwise use it.
The URL can consist of a SELECT statement and refers to the PC 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:
http://badblue.com/helpsql.htm
You can require authentication, allow updates, etc. if you wish.
Dave
Effectively, it lets you create a URL (which you can send to a remote user and they can bookmark). When they plug the URL into their browsers, they can view CSV, tab-delimited or XML versions of the database data. They could then import it into their own Excel or Access data or otherwise use it.
The URL can consist of a SELECT statement and refers to the PC 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:
http://badblue.com/helpsql.htm
You can require authentication, allow updates, etc. if you wish.
Dave
