[AccessD] Observations on AC 2007 (not good)

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



I hear you Mark, as a prolific user of custom commandbars that could be docked where best suited the user / layout I found the complete destruction of this functionality to be a stunning foul up.

Frankly I found many things about A2007 that stank.  A2010 is better, but you will still have the toolbar issue.  Like you, I am stunned this got past beta testing - although IMHO A2007 is a beta test version....

Still unhappy about that lill development...

cheers
Darryl.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Thursday, 25 November 2010 4:04 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Observations on AC 2007 (not good)

As I am furiously hacking away at AC 2007 for a client, I've spotted some
problems I have not seen documented.
Here they are:
1) I observed that when changing an ACCDB to an MDB for purposes of using
Access 2003 and Access 2007 there a bug in this conversion process ...it
removes the USysRibbons table. Access 2007 still can operate without one.
However, without that system table, you cannot do any customization of the
ribbon by assignment from the Ribbon and Toolbar options setting ! The only
alternative is the LoadCustomUI vba method.
The fix: cut-and-paste the USysRibbons from an ACCDB file; then change the
Attribute to the proper system table attribute -2....... something. That
last step is important.
 
2) Commandbar menu items built in AC 2003 show-up ONLY under the "Add-ins"
tab of AC 2007. OF COURSE THIS STINKS HUGELY. If you assign a custom Ribbon
that does not have an Add-ins tab, YOUR COMMANDBAR MENU IS LOST....your
users cannot do anything !
Microsoft easily could have provided a database-level setting for the
flexible placement of the commandbar menu onto the Ribbon. How this major
oversight ever got past beta testing only confirms my feeling about the
political nature of the selection of the beta test team. I would go so far
as to indict the product manager of Access for such a grevious oversight and
lack of attention to detail.
 
3) The AC 2007 ribbon can be minimized and indeed that setting "persists"
upon the next database open. Minimizing it via the GUI is simple. Doing it
with VBA is nearly rocket science with a ton of Win API calls required for
it to be reliable. Note: in AC 2010, a new DoCmd was added to minimize the
ribbon. (it took 3 YEARS to figure that out ?)
 
It doesn't take a genius to see why AC usage and acceptance in corporations
has now dropped to very low levels. Anyone associated with the beta testing
of AC 2007 should immediately disavow all knowledge of any interaction with
Microsoft Access engineers and managers involved in that program at the risk
of major verbal abuse by beleagered colleagues.
 
 
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________