Launch MS Access Project from web page

[Erica Dunn]

Hi all. I'm trying to launch a .adp file from my web page. The
application is residing on the intranet, and the .adp file would be
located on a shared drive that everyone would have rights to. Right
now when the user clicks the link, a download box opens that prompts
them to save or open the file. If they save it locally it works fine.
If they try to open it, an error is given, saying "The file is
located outside your intranet or on an untrusted site. etc... ". The
powers that be don't want this extra step of the user having to save
the file locally before opening it up. They don't want the users
downloading the file to their machines. Any suggestions would be
greatly appreciated.

 

[Mary Chipman]

Access is designed to be a local, file-based database, and works best
when each individual has a copy of the .adp on their local
workstation. The .adp contains the front-end objects (forms, reports,
code, etc.) and a link to a SQL Server database. So as a result, you
have permissions involving not only the Access objects to consider,
but also access to SQL Server (which you may or may not be handling by
using SQLS logins instead of Windows authentication). In short, an
Access .adp is not designed to be a web application. You should
consider a scenario where you deploy the .adp to all of the users who
need it and let them run it on their local machine. If you're worried
about them modifying .adp objects, then compile it as an .ade.

--Mary