I usually use MS Access to build tools for small teams to use on projects but these days I can’t believe there’s not something slicker out there….is there?
We need to set something up to assist with account (Active Directory, Unix etc) administration. They process joiner, mover, leaver and add and remove access requests and are drowning. Add attestation/recertification to the mix and their s/sheets and manual workarounds mean the team’s only ever chasing its tail and never improving.
We need something that can import text files build query and manipulate that all together to get a picture of a user’s accounts and access and then take text file inputs from Human resources and the request catalogue tool and then manipulate all that to set up some sort of workflow/to do list for the support staff to work on.
Using Access I find it really hard to make a good looking interface and a sometimes struggle to nicely separate out all the SQL from VBA. After a lot work and re-work I usually end up with something mechanically suitable but it still looks rough and I would have had to do every bit myself from scratch.
I’ve heard of Mashups but can’t seem to find anything that would suit after a nosey round the internet.
So esteemed CUKers, please chip on your ideas for what I can use either alongside or instead of MS Access to do much slicker job of this.
P.S. I might be able to get an MS SQL DB set up and possibly use SSIS to handle the file inputs and email outputs but I need to get this prototyped in double quick time.
Thanks
We need to set something up to assist with account (Active Directory, Unix etc) administration. They process joiner, mover, leaver and add and remove access requests and are drowning. Add attestation/recertification to the mix and their s/sheets and manual workarounds mean the team’s only ever chasing its tail and never improving.
We need something that can import text files build query and manipulate that all together to get a picture of a user’s accounts and access and then take text file inputs from Human resources and the request catalogue tool and then manipulate all that to set up some sort of workflow/to do list for the support staff to work on.
Using Access I find it really hard to make a good looking interface and a sometimes struggle to nicely separate out all the SQL from VBA. After a lot work and re-work I usually end up with something mechanically suitable but it still looks rough and I would have had to do every bit myself from scratch.
I’ve heard of Mashups but can’t seem to find anything that would suit after a nosey round the internet.
So esteemed CUKers, please chip on your ideas for what I can use either alongside or instead of MS Access to do much slicker job of this.
P.S. I might be able to get an MS SQL DB set up and possibly use SSIS to handle the file inputs and email outputs but I need to get this prototyped in double quick time.
Thanks
this is about building a working prototype/tactical solution to convince glacial paced management. This solution MUST be internal, cloud solution is appropriate. Too many hoops to go through.
Comment