I am trying to carry out a statement like:

UPDATE table1 SET name="Joe" WHERE id='1'; UPDATE table2 SET name="Bob" WHERE id='2'

But, when performing the query, I recieve:

Microsoft JET Database Engine error '80040e14' Figures found after finish of SQL statement.

It really works after i execute the claims individually, though.

So I am speculating there's no way to complete multiple queries in one SQL statement when utilizing Microsoft Access/JET database engine?

No, there's no method of doing this except through VBA or so on, once the claims could be Performed seperately, but like a single procedure.