Putting a ACCDE on the web?

[joe789]

Hey Folks,

I have created quite a few ACCDE files with the front end being MS Access as a ACCDE to compile the code and connection strings hitting the back end of SQL Server ... some of the programs, all single file, are quite elaborate with forms and VBA in the background. Every time I update one of these applications, for whatever reason, I have to e-mail the user a new ACCDE file to use and instruct them to delete the prior version so as to ensure they are hitting the newest program; although this doesn't happen often, I would love to somehow someway easily perhaps put this ACCDE on some sort of web server, if you will, so that these folks can simply just go to a web address and essentially run the ACCDE in that way rather than clicking on the physical local ACCDE file on their PCs. Is this possible? Is this practical? Is there an easy way to do this? One major issue is that if I cannot retain all the structure, forms, layout, VBA code in the background that has event driven processes and macros then I cannot do it anyways.

Any ideas would be greatly appreciated.

Thank you,

Joe

 

[Solo712]

Hey Folks,

I have created quite a few ACCDE files with the front end being MS Access as a ACCDE to compile the code and connection strings hitting the back end of SQL Server ... some of the programs, all single file, are quite elaborate with forms and VBA in the background. Every time I update one of these applications, for whatever reason, I have to e-mail the user a new ACCDE file to use and instruct them to delete the prior version so as to ensure they are hitting the newest program; although this doesn't happen often, I would love to somehow someway easily perhaps put this ACCDE on some sort of web server, if you will, so that these folks can simply just go to a web address and essentially run the ACCDE in that way rather than clicking on the physical local ACCDE file on their PCs. Is this possible? Is this practical? Is there an easy way to do this? One major issue is that if I cannot retain all the structure, forms, layout, VBA code in the background that has event driven processes and macros then I cannot do it anyways.

Any ideas would be greatly appreciated.

Thank you,

Joe

Hi Joe,
I would recommend creating a VBA routine that runs on opening the database that checks the version of the app kept in a local table against the current version in a param table of the BE !. If they do not match, the newer ACCDE version (which has the FE param table) is copied to the workstation. User is informed that a new version has been installed and the application terminates. On re-opening, the user has an updated ACCDE file to work with.

Best,
Jiri