I had to develop a simple CRUD interface for some of our analysts.
The immediate problems I faced was:
1) The analysts wanted every (CRUD) step to happen within excel - excel was indeed going to be their interface, so I needed something which I could launch from within excel.
2) The IT department refused me to grant command line access
3) The IT department refused me to install non-approved dev tools. To get them approved, would potentially take months.
4) The DB admins weren't too keen on letting me add a new DB to the existing Oracle DB. The IT department weren't too keen on me doing my own DB (see step 3)
Hell, just getting new add-ins to excel requires me to BEG the IT folks. And if I'm lucky, the add-ins will just suddenly appear. Will it take a day? a week? a month? Who knows.
So keeping all those things in mind, my only real alternative was VBA.
In the end I managed to get some permatemp solution up and running, which the analysts use once every two weeks.
The immediate problems I faced was:
1) The analysts wanted every (CRUD) step to happen within excel - excel was indeed going to be their interface, so I needed something which I could launch from within excel.
2) The IT department refused me to grant command line access
3) The IT department refused me to install non-approved dev tools. To get them approved, would potentially take months.
4) The DB admins weren't too keen on letting me add a new DB to the existing Oracle DB. The IT department weren't too keen on me doing my own DB (see step 3)
Hell, just getting new add-ins to excel requires me to BEG the IT folks. And if I'm lucky, the add-ins will just suddenly appear. Will it take a day? a week? a month? Who knows.
So keeping all those things in mind, my only real alternative was VBA.
In the end I managed to get some permatemp solution up and running, which the analysts use once every two weeks.