So if you want to put your mdb file on a shared LAN drive and have users open it by clicking a button on the intranet, how do you do it? I don't want the .mdb to open in a browser. I just want to launch the local installation of MSAccess and have it open a particular .mdb. I added a link to the file from the html but IE asks if you want to download or open. If you choose open, nothing happens but a lock files appears in the folder where the mdb is. If you manually type file:///c:\mymdb.mbd in the address bar of the browser, it opens as desired and this is what I want to emulate in a button on the intranet page. I want the users to be able to click a button on our intranet page to open the frontend of the database. The backend is also on a shared drive (the path is the same for everyone). At most, only 3 people will be using the database at any one time. I've searched the forums and have not found a solution. Thanks in advance for any ideas.
I tried the simple <a href approach a couple days ago and all it does is create a lock file in the folder where the .mdb resides. MSAccess never actually opens. And the lock file does not appear until after I hit the "Open from this location" option (I'd really like to circumvent that too). I wonder why it didn't work for me?
I tried creating a .bat file that launches the MSAccess.exe and opens the .mdb I want and this seems to work. What I have is a link (or button) on the html page that uses the path to the .bat as the url. When the link is clicked, you still have to click "Open from this location" but then the .bat executes and the database actually opens.
I really want to get rid of the "Open from this location" though. It seems like it's possible since if you type "file:///<path to .mdb>" in the browser address bar, the file opens as desired.
