I require an ASP page that will enable an administrator to manage reference data within an intranet system. The database is MS Access 2002. The requirements are: 1. The data tables allowed to be managed/modified will be stored in a table called “ModifiableTables??. This list of tables is to be populated into a combo box. The administrator will select the table they wish to modify. The table “ModifiableTables?? has two columns, one for the description to be populated into the combo box and the other is the actual name of the table in the database. 2. The table selected will appear in a table below the combo box excluding the audit trail, identified by (*_IB, *_IT, *_UB, *_UT). Each item will be a hyperlink which the user will be able to select. Once selected the user will be able to edit and then save. Each table can potentially have different columns. 3. New items will need to be able to be added to the table. 4. When saving the Updated By and Updated Time will be updated to the administrators logon and the current date. Logon is stored in session variables. 5. If when saving data to the database and any referential integrity rules for the database are broken, meaningful messages should be displayed and NOT a server error message. The page is to be written in ASP with VB and possibly some Java. It should be optimized for 800x600 resolution and should be compatible with most browsers.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Well commented code. 3) Complete ownership and distribution copyrights to all work purchased.
## Deadline information
Code must be well Commented. Written in ASP with VB and possibly some Java. Should be optimized for 800x600 resolution. Should be compatible with most browsers.