Just for fun.. I made and access table and used the same code I posted here. It runs without a hitch. I made a VFP table and did the same with it.. No problem..

I wonder if something has happened to the validity of my table that ADO doesn't like. These are existing VFP tables that have been around for a few years now.