I have developed a few forms for analysing data on a access database. Now I would like to know if it would be possible to host the forms on a link over the net having the database in a different system. Basically I want the database to be in a different system, the user should see the forms and use it but all 开发者_如何学运维processing, must take place in the system where the database is. The user must then be able to see the results.
Is this possible?
No, it's not possible. The web has a separate client for user interaction (usually the browser) and a server for storage. Browsers do not support Access for GUI interaction.
However, you can still use Access for storage (although this is not advisable), but you will have to find a solution for converting the Access forms to web forms. Fortunately, there are plenty of tools available that can do that for you.
There are various limitations in Access/Sharepoint combination. Like union query is not supported in web access and other things. Access can be better deployed over net by using remote connection with mysql (or other server dedicated or cloud) as backend.
Since Access 2010, it is possible to run Access forms on-line. This can be seen in Access 2010: Outlook-Style Calendar in Browser, by Albert Kallal
精彩评论