good afternoon!
I apologize in advance if this has been asked innumerable times, but the Search function is down right now and I am tearing my hair out.
I have an administration site for my intranet which allows certain users to add records to various SQL database tables using CF forms. For example, there is an admin piece for Job Postings, Employee Info, Phone Numbers, etc. The data is viewed by the general employee population through the main intranet site.
My problem is that we are not totally networked yet and my administrators still need to print out paper reports. Currently, I have them all set up with MS Access Databases which have linked tables from the SQL database which generate the reports.
My brilliant idea this morning was to use a command button on the admin page to locate to a page with a CFEXECUTE tag which would open MS Access and run the reports, transparently to the user. However, apparently CFEXECUTE can only work on the server on which CF server resides. So the first thing I would have to do is install MS Access on two servers, our development and our production servers. Next, running Access reports on those server raises the issue of how to get the print-out to the various local printers.
This is getting very complicated. I am interested in what others in my situation have done. Many companies must be in a similar situation; transitioning between paper-based and browser-based.
Thanks for any input, suggestions, and/or war stories you may have.
Kathryn
Kathryn
I apologize in advance if this has been asked innumerable times, but the Search function is down right now and I am tearing my hair out.
I have an administration site for my intranet which allows certain users to add records to various SQL database tables using CF forms. For example, there is an admin piece for Job Postings, Employee Info, Phone Numbers, etc. The data is viewed by the general employee population through the main intranet site.
My problem is that we are not totally networked yet and my administrators still need to print out paper reports. Currently, I have them all set up with MS Access Databases which have linked tables from the SQL database which generate the reports.
My brilliant idea this morning was to use a command button on the admin page to locate to a page with a CFEXECUTE tag which would open MS Access and run the reports, transparently to the user. However, apparently CFEXECUTE can only work on the server on which CF server resides. So the first thing I would have to do is install MS Access on two servers, our development and our production servers. Next, running Access reports on those server raises the issue of how to get the print-out to the various local printers.
This is getting very complicated. I am interested in what others in my situation have done. Many companies must be in a similar situation; transitioning between paper-based and browser-based.
Thanks for any input, suggestions, and/or war stories you may have.
Kathryn
Kathryn