Top Contributors

What features do you feel are currently missing from Access?

Access has been around for a number of years and is considered a "mature" product.   Do you feel it's complete or are there still features that you'd like to see?   What types of problems do you have that Access can't handle?
View Previous CommentsLoad All Comments (47)
Rank: Genius

Expert Comment

Bitsqueezer2016-02-11 01:50 PMID: 1895079
I don't believe that's a bug but a "feature"...:-)
It says clearly that I cannot enter a new idea if I have no free votes anymore.
0
Rank: Savant

Expert Comment

But since others have entered a new idea (they clearly have votes left) - but do not have to vote on their idea ... seems it's a bug.
I will ping the Access Team on this.
0

Expert Comment

Liberty4all2016-02-26 04:12 PMID: 1897700
I realize I'm late in contributing to this discussion but Jim Dettman's question is too compelling to not provide a response.  I love Access very much will offer my two cents worth in responding.

I would love to see the following added to Access: increase the maximum file size well beyond 2 GB, add more built-in statistical functions, and a better graphing tool with more options.  My biggest wish, however, is to do whatever is necessary to make IT people accept it.  Whatever the issue (security is the one I hear the most), my plea is for Microsoft to do whatever is necessary so IT departments will find Access acceptable as an application worthy of their support.  

The simplicity of using Access cannot be beat.  Of all the applications I've worked with over the years, none do a better job of allowing one to join tables and create queries as easy as can be done in Access.  The sad news is my days of using it are numbered as I'm being forced to learn other systems that are my employer's "standard".  Those other systems are more robust, but the learning curve is significantly greater and depending on the task at hand, if the same thing can be done easier in Access then I would certainly prefer to do it that way.  That's not the way things work, of course, so it's just a matter of time until I'm forced to become a "former" Access developer.

Jim, if you have any words of encouragement I would appreciate hearing them.  I feel Microsoft has failed to do what is necessary to keep Access as a viable tool in today's demanding environment.  My late mentor (also an MVP) could do more with it than even Microsoft realized was possible, but it doesn't appear they acted on his recommendations.
0
Rank: Prodigy

Author Comment

Jim Dettman (EE MVE)2016-02-27 02:36 AMID: 1897740
<<I would love to see the following added to Access: increase the maximum file size well beyond 2 GB, add more built-in statistical functions, and a better graphing tool with more options.  My biggest wish, however, is to do whatever is necessary to make IT people accept it.  Whatever the issue (security is the one I hear the most), my plea is for Microsoft to do whatever is necessary so IT departments will find Access acceptable as an application worthy of their support.>>

  I would love to see all that happen, but I doubt any of it will.  The issue with file size is somewhat of an architecture restriction in the way that JET/ACE generates locks.  I haven't done the numbers, but it uses 512 bytes per page to represent a lock.   First 256 bytes are read locks (one byte per user) and the second 256 are used for exclusive mapping.   They also use a range of bytes to represent different types of locks.  So the problem ultimately is how pages can you address when you do your locking like that. Not sure what they did either to get record level locking (no details on ACE have ever been released).

 On the stats and graphing, they've already indicated a move towards Excel as being the answer.

 Workgroup security was removed rather than being fixed and with the backdrop of SQL Server having moved onto the desktop, it's hardly worth it to fix it.  But even with SQL as a data store, the main problem with Access is that it is too sensitive to it's environment to be all that workable for any large projects.  That, and the lack of being considered as a developers tool (ie. lacking support for n-tier designs, 3rd party controls, etc).

 Last, Microsoft now has a keen focus on the web.  No new work on the Desktop side of things since A2007 and I doubt you'll see that change.  Microsoft has left the desktop behind.

 They also seem to have a renewed focus on placing Access in the hands of the power user.   To be fair, Access was never marketed as a developer tool and always as an end user one.   But as you rightly point out, many have taken it places where it was never designed to go, and have done so well (and for a great example of that, checkout Bitsqueezer's CCSlider db - wish I could turn out interfaces like that!)

 So I'm afraid no words of encouragement other then to put your thoughts (and votes) onto Access Voice.

  One thing I've learned, is never say never.

Jim.
0

Expert Comment

Liberty4all2016-02-29 08:47 AMID: 1897974
Jim, thanks for your comments.  Regarding "On the stats and graphing, they've already indicated a move towards Excel as being the answer" does this mean Microsoft is going to add more Excel-like functionality to Access, or are they recommending folks use Excel more as an alternative for that purpose?
0
Rank: Prodigy

Author Comment

Jim Dettman (EE MVE)2016-02-29 10:37 AMID: 1897991
The later :(

Jim.
0