Help running SQL Update Via VBA (Missing Operator Debug Error)

I don't think it will like:

tbl)_Master

but that seems to be too obvious of an error. Have you tried running the sql statement directly in your SQL editor in Access? Or better yet, copy the SQL string to the SQL window then switch to the QBE grid. That should give you some decent error messages.

I caught the table)_master shortly after posting the message, that wasn't the issue Thanks for the tip with trying to run the code directly in SQL, I will try that and see what errors that will produce.

I figured it out I had to modify my SQL to read like this:

Please Login or Register  to view this content.