I ran into this on the internet.. I think that it’s funny.. because I think that Access Data Projects include all 5 of these features already:
Q: New Feature 1 – Recording Macros
A: I use SQL Profiler for this!!! It works great, especially on large Access conversions!
Q: New Feature 2 – One, better macro language
A: I use TSQL for this! IF WHEN THEN BEGIN WHILE, that’s all done on the SQL Server side, buddy!
Q: New Feature 3 – Get rid of the bugs
A: I stopped using Jet 10 years ago because it’s not stable, it’s not possible to stabilize.
Q: New Feature 4 – Include an SQL Editor
A: Access Data Projects -IS- a SQL Editor!
Q: New Feature 5 – Deter Casual Users
A: Access Data Projects take about an extra week to teach developers to be productive. BFD, It’s worth it.
Microsoft Access 2012 Wish-List – Five Things We’d Like to See in the Next Version of MS Access
By Andy Brown
Dec 21, 2010
Sometimes it’s not easy to see the database wood for the trees. This article attempts to stand back and consider 5 features which Microsoft could include in the next version of Access (2011? 2012?).
New Feature 1 – Recording Macros
Microsoft, the time has come! You can record Visual Basic macros in Word and Excel, and you used to be able to record in PowerPoint too until recently. We recognise that it wouldn’t be an easy feature to include, but it would make writing VBA macros so much easier!
New Feature 2 – One, better macro language
You keep trying to improve the Access macro language, adding better comments and much more in Access 2010. Ultimately, however, it’s Visual Basic which provides the power that most developers need.
We’d like to see Microsoft announce that they will no longer invest in the Access macro language, but will work to improve the VBA language. Specifically, please can we get rid of DoCmd and RunCommand, and also abandon the forms![formname]![controlname] convention? Word and Excel VBA has converged: it’s time to bring Access into the fold.
New Feature 3 – Get rid of the bugs
The worst feature of Access, by far, is that it isn’t reliable. Every time that we use it to develop a system, we swear that we will never do it again (and then forget this promise the next time!).
We’d like to see the Compact and Repair feature removed from Microsoft’s next Access version – because it wasn’t needed.
New Feature 4 – Include an SQL Editor
For those who know SQL Server but – understandably – prefer the Access user-interface, a SQL editing window would be a godsend. If we could have it with colour-coding, indentation, comments and autocompletion of commands, so much the better. Basically, couldn’t Microsoft include the SQL Server Management Studio 2008 window within Access?
New Feature 5 – Deter Casual Users
We’re not entirely serious about this last new feature, but …
We’ve seen far too many companies building Access “databases” which consist of a single table, and which would have been better created in Excel. So, how about a feature which displays a warning message when you create a single-table database (or a multiple-table database with no relationships) saying something like “This database might be better created in Excel!”.
If anyone from Microsoft would like to comment on this article, they’d be very welcome!
About the Author
Andy Brown has been building Access databases and running Microsoft Access training courses for Wise Owl Business Solutions for many years. You can see all of the courses that Wise Owl run at http://www.wiseowl.co.uk.