[AccessD] Observations on AC 2007 (not good)...more..and more...

Mark Simms marksimms at verizon.net
Thu Dec 2 20:02:05 CST 2010


Opened an AC2003 MDB that had a form using MSCOMCTL's "Listview" control.
Environment: Windows 7 64 Bit with AC2007 / SP2.

I try to debug the VBA code where the Listview control population was
occuring.
Access IGNORED my STOP statement; ignored all BREAKPOINTS.
However, the code did compile cleanly (go figure).
This was driving me crazy (we've all been there with Access, right ?)

So I fire-up REGEDIT and find the reference to the MSCOMCTL.OCX.
There are TWO of them...one in \Windows\System32....the other in
\Windows\SysWow64.

So I pull up the References dialog box within the VBA environment.....and
note there are no references to MSCOMCTL showing !
I browse to SysWow64, find the MSCOMCTL.OCX which was dated 2008, add it,
and move it up in priority.
I close AC2007, re-open....and ALL IS WELL. I can now debug again !
But more importantly.....Hey....
I like that Listview control with the sortable column headers....why didn't
MSFT make that a native control in 2007 ?





More information about the AccessD mailing list