Hi all,
I'm attempting to insert data into a table through VBA.. but getting stumped on the error message in the subject line.
Where I'm stumped is that the code executes just fine when I'm only trying to insert data into 2 fields.
I temporarily updated the code to include a "Debug.Print strSQL" (instread of "DoCmd.RunSQL (strSQL)) so I could see what the actual SQL string was.
This one works:
Code:
INSERT INTO tblDB_Users(USERID, ROLE) VALUES("jdoe", "read_only")
This does not (produces the run-time error 3134):
Code:
INSERT INTO tblDB_Users(USERID, DATABASE, ROLE) VALUES("jdoe", "MyDB", "read_only")
Is there something blindingly obvious I'm missing with the second iteration?