I give up. I know this is something dumb, but I just can't figure it out.
I'm executing the following "INSERT INTO" statement on my (Jet) database.
INSERT INTO tblGrandLodgeCommunication
s (MemberID, BackupName, Date, Communication) VALUES ('204', John H. Doe', '40174.8401551157', 'blah');
I've verified the name of the table and the names of the four fields within the table. The simple table schematic is in the image below.
I keep getting "Syntax error in INSERT INTO statement."
If it helps, I've also attached the output from clicking "Copy exception detail to clipboard."
Any help will be much appreciated.