Discussion Locked

Exec mdb file from HTML page possible?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am wondering if it is possible to run an Access 2000 database from a HTML website on a corporate intranet. For example, when a user clicks on "The Great Access Database" from the website, I want the click event to execute a particular Access database on a fileserver in the same way as if a user were to click on a desktop icon that runs the Access executable and connects to the mdb file located on the fileserver. I do not want to have to create Data Access Pages or try web publishing the database or what-not; I only want users to click on the labels on the HTML page that actually runs and executes the Access database. Previously, I had deployed desktop shortcut icons on the client computers that ran the Access databases out on the fileserver; also, I had created desktop shortcut icons of batch file scripts that would execute the Access databases with startup options. I simply want to replace the desktop icons with an intranet portal site that accomplishes the same purpose. Please let me know if this possible; I don't care whether the solution involves the correct HTML tag, VBScript, JavaScript, etc.

2 replies

by the-shelter

O.K. lat's make it short as echrepublic just erased my answer...
2 possibilities:

1- simply link from the web site to the 'access db' scripts you already have installed on your clients' computers.
For exemple Trigger DB
runs adaware on my win32 box.

2- Get into XML: This requires a little webserver manipulation/extension but is very reliable.

3- Do it with PHP. You have to install a PHP extension on the web server which is available for all major platforms. A simple tutorial how to access a db can be found on http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
This is for mysql but it will teach you the basics in half an hour!
http://www.phpbuilder.com/columns/siddarth20000228.php3
Here they access an ACCESS DB!
You simply have to see how they interact with the DB to learn how you can solve your problem!
If you have further questions just let me know.
Hope this helps.
By the way: I strongly recommend to use a secure way. If you want everybody to have access to your DB you certainly can do it a whole lot easier with Java Script/Perl(or bash).

This discussion is closed to new replies.