Trust in Access

One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you get a prompt to ‘Enable Content’, designed to prevent malicious code from running without you knowing it. I tend to just leave it open for long periods and so it doesn’t bother me much, but […]

Another Strange MS Access Gotcha

This past week I needed to retrieve a spreadsheet from a Sharepoint library, add a column to a sheet, and then populate that column based on some data I had in Access. Rather than import the data into Access to make the change and then export back (which could overwrite any formulas, lose comments, etc), […]

No Full Outer Join in Access

Recently I needed to help a colleague with a small inventory true up task. We needed to know items that were in List A and not in List B, and vice versa. It was a universe of about 1000 items with a good sized delta, 15 to 20 percent. For tools I had the options […]