The “Find and Replace” can be improved a little by:

1. Change these dialogs to default to expanding the search
2. Move the dialog if it is covering the found text
3. Change the message box to say:
   • 0 records found in the field ‘SupplierID’ for exactly ‘Olive’. Would you like to expand the search to try “like ‘Olive'”? [Yes] [No]
   • 0 records found in the field SupplierID? Would you like to expand the search to all fields? [Yes] [No]

Microsoft Access should support the ability to compile an Access Database to an EXE so that the end user cannot see the tables and queries.

I wish could copy the text via a button “Edit Macro XML”… And the XML was formatted nicely :-)

    < ?xml version="1.0" encoding="UTF-16" standalone="no"?>
    < DataMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application">< DataMacro Event="AfterUpdate">
    < Statements>< ConditionalBlock>< If>< Condition>[Table1].[Salary]>50000< /Condition>< Statements>< EditRecord>< Data/>
    < Statements>< Action Name="SetField">< Argument Name="Field">Table1.Notes< /Argument>< Argument Name="Value">
    "he is paid too much"
    < /Argument>< /Action>< /Statements>< /EditRecord>< /Statements>< /If>
    < Else>< Statements>< EditRecord>< Data/>< Statements>< Action Name="SetField">< Argument Name="Field">Table1.Notes
    < /Argument>< Argument Name="Value">"too little"< /Argument>< /Action>< /Statements>< /EditRecord>< /Statements>< /Else><
     /ConditionalBlock>< /Statements>
    < /DataMacro>< /DataMacros>

Figure: This ugly URL should be changed to nicely formatted XML

This Microsoft utility is not ready SQL Server Migration Assistant Wizard for Access.

• Allen Browne has some Flaws in Access located on his
• The Access community speaks up in Gary Robinsons article

As per http://www.joelonsoftware.com/items/2005/10/17.html

It was a great tool that was discontinued. It should reappear in Access!

Users should be used to “discover” data… and only afterwards, go into Excel or Reporting Services.
If the cube is decent (Levels / AVG’s, MAX’s, etc), it’s a really cool thing. it’s shocking that we don’t promote it as real world tool for execs and I hope MS keeps upgrading it.
Note: Not saying to show any MDX that is advanced and MDX can be done manually or in Proclarity (not Panorama).

Maybe OLAP data is a bit of a move away from core stuff but then again so is SharePoint integration in Access 12 and that does not seem to be a bad thing.

If you call

       SELECT * FROM Customers WHERE CustomVBA_BusinessDays(DateStart, DateEnd) > 200

This would be slower than

       SELECT * FROM Customers WHERE CustomerID='BOLID'

Please log to a log table (or a trace file in the current directory).

Encourage the use of writing Unit Tests.

Change Northwind to have a class of Unit Tests.

Make a way of calling nUnit as its test harness.

Microsoft’s Access Snapshot Viewer is a useful tool for viewing and printing Snapshot files (*.snp). While we can use its graphical interface, it would be good if the program could also be operated using command-line switches, such as ‘/openfile’ or ‘/print’.