For some reason, this was preventing the update to the dB from showing. Once I did this, everything worked fine.
Do you have any ideas as to why keeping the connection open preventing me from seeing the rows added to the dB? Or is this a quirk associated with Acccess? I am guessing that the table was locked due to the open connection and therefore not accepting new inserts....?
Again, thanks tons for your quick response.
Hope you have a great day!
author & internet detective
Some drivers don't do the database commit until you close the connection. I don't enough about Access to say whether this is the case here. But it is a possible explanation for why you weren't seeing the updates.
subject: How to insert date into MS Access Date/Time?