Dalkeith (7/18/2014)
I personally like MS Access. Its sweet spot is definitely complicated internal systems with limited distribution and users but that covers a great deal of systems.I would prefer to use SQL Server as the back end and just use Access for UI design.
I also believe it is an excellent tool for teaching database design principles and UI design principles.
It is probably undervalued as a UI design tool.
I'd have to agree. There was a lot of power built-in, if you only know where to go to tap into it. Interestingly enough there were also a lot of tricks to "dummy-proof" applications, if you only went looking for those: the ability to use external MDE's as data and UI "libraries" made it easy to deploy ongoing changes to everyone, without giving the end-users unfettered access to every product table.
Of course - you had to WORK to leverage some of these items: it's easier to build a giant security violation thant is it not to 🙂
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?