This is getting pretty annoying. This SQL statement runs fine in Access:
SELECT payrecords.*, employees.name AS employee
INNER JOIN employees ON payrecords.employee_id = employees.id
WHERE payrecords.payrun_id = ?
ORDER BY employees.name;
The TableAdapter query parser in Visual Studio seems to have difficulty dealing with (moderately) complex SQL statements that end with a semicolon (
;). In this case, simply removing the semicolon from the end of the statement resolved the issue.