Managing Microsoft Access Autonumber Fields

  Yeah, I know what you’re thinking... "Why do autonumber fields need to be managed? Don’t they manage themselves?" Well, yes, autonumber fields are pretty much self-managing, but there are times when you, as a database manager, may need to repair a table with an autonumber field and you’re sca [...]

2023-07-26T09:23:59-05:00July 26th, 2023|

The State of Access in 2023

The future of Microsoft Access in 2023?  Earlier this year I was in Redmond, Washington, to participate in the MVP Summit, where I heard a lot about AI and Office and met with the Access team (it’s one of the best benefits to being an Access MVP). Although I can’t share much of what we discussed, I’ [...]

2023-06-06T10:34:48-05:00June 5th, 2023|

The Highly Popular Yet Confounding Access Datasheet: Bug Fixed!

Over the years (almost two decades), there was (it has been fixed now in the latest versions) a glitch in the Access Datasheet Wizard that created a confounding condition that led many to take to the help forums to find a solution. You see, one of my favorite features of the datasheet is using the c [...]

2023-05-15T11:27:46-05:00May 12th, 2023|

Understanding how Access deletes records

It is common to run across questions about how Access handle deletions, particularly from the VBA code. The Access form provides 3 events around the deletions but they are easily misunderstood. I attribute this to how the events are presented in the Property Sheet's Events tab: If all we did was jus [...]

2023-05-03T16:34:59-05:00May 2nd, 2023|

Can ChatGPT write VBA code? How about SQL Queries? Yes! But…

I've been playing with ChatGPT for a while now and mark me impressed with its capabilities. One of the first things I did was ask it to create a VBA function that calculates the first of the month: A couple of points on the code above: I never named the function yet the AI used a great name: FirstOf [...]

2023-01-24T17:32:01-06:00January 22nd, 2023|

Updating your SQL Drivers can be a pain, unless you do this

It seams Microsoft is releasing new drivers every few months now, trying to keep pace with the trove of new SQL Server and Azure features that come out with every new version. The drivers do double work, both with the product you can install locally, and the Azure service in the cloud. Why you shoul [...]

2022-12-04T11:59:26-06:00December 4th, 2022|

No meeting tomorrow, join me on December 13th

I am currently traveling through the Middle East on a entrepreneurship training course through Israel where I’m meeting startups and getting a ton of ideas for my practice. Consequently we will not be having our normal meeting in November and our next meeting is in December 13th 2022. Here are the m [...]

2022-11-07T10:39:02-06:00November 6th, 2022|

How I bombed at my last presentation – yes, it happens to all of us

Last Tuesday, October 11, 2021 I was all set to present SQL Server with Access Academy Part II when I hit a roadblock I could not overcome: SQL Server Migration Assistant for Access, (SSMA), would not load the sample Northwind database and I was stuck, could not continue the session. I've done it fo [...]

2022-10-26T16:05:33-05:00October 26th, 2022|

Azure mandating TLS 1.2 may break dependent .NET libraries

We got a pleasant surprise when one of our clients reported to us that the application was no longer. In this case, it had a .NET DLL that called Azure service. The code was very straightforward; just reference a nuget package provided by Microsoft and call methods on it and it just works™. Few mont [...]

2022-08-05T09:16:52-05:00August 5th, 2022|
Go to Top