SQL 2005 Database Front End
Posted on 2009-02-15
Presently, I have several Microsoft Access databases on a network drive that is used by roughly 30 office staff. The front-end forms have all been carefully designed and use no macros...all visual basic coding.
We have just completed the construction of our Intranet (which is on an SQL 2005 server) and utilizes Active Directory log-in controls and we have people which monitor the server traffic 24 hours a day to ensure there are no security issues...so there is little concern about someone using the intranet to hack our servers.
What we now want to do is move the Access tables to the SQL server AND recreate the Access Front-End forms on the intranet (obviously in web pages).
I have gotten many many different answers on the easiest way to go about creating the web front-end but nothing definitive yet. At present, the user MUST be able to query information from the tables and be able to do data entry into the tables WITHOUT the user accessing the table data directly (do not want to display the table on the screen preferably).
So my question is this...what is the best way to go about designing a user web front-end for the database? Should it be in a particular language (as opposed to another)? Are there already very good programs which have been designed for this purpose?