I have created a table of employee user_id's (multiple systems) that
allows us to tie transactions to sales agents for a commission
program. The table is in our production Oracle database and multiple
systems use it as a cross-reference source.
Our help desk will be updating this table whenever there are new
hires, terminations, etc. Right now I am doing that manually. Ughhh.
I'd like to develop a simple interface to allow them to perform the
updates and inserts (no deletions, we leave de-activate the user_id's
on and keep the reference on the database for historical analysis).
In a previous shop, I created a Java servlet that would read, update,
etc an Oracle database. I don't want to go thru all that trouble
again. Is there a simple way I can allow these users to update the
table? I was thinking:
- Visual Basic
- Microsoft Access linked table (derivative of the VB idea)
- Java Applet
Any ideas? Need it to be rather simple because of the time I've
allocated to the development. Very few users (5) doing minimal
updates (a couple a week).
