SQL 代码在 Access 中工作，但在 Visual Studio 中不起作用

我有以下SQL代码，它是使用Microsoft Access中的查询设计视图生成的。

SELECT tblLoan.BorrowerID, tblBorrower.BorrowerFirstName, tblBorrower.BorrowerLastName, tblBorrower.Address1, tblBorrower.Address2, tblBorrower.City, tblBorrower.ContactNumber, tblBorrower.DateOfRegistration, tblBorrower.Gender, tblBorrower.Email, tblLoan.LoanID, tblLoan.ReceivedBy, tblLoan.Fine, tblLoan.CostPerDay, tblLoan.OverdueDays, tblLoan.OverdueFine, tblLoan.AdminID, tblBookLoan.BookID, tblBookLoan.DateOut, tblBookLoan.DateDueBack, tblBookLoan.ReturnDate, tblBook.Title, tblBook.Author, tblBook.ISBN, tblBook.PublicationYear
FROM tblType INNER JOIN (tblBookType INNER JOIN (tblBookCategory INNER JOIN ((tblBorrower INNER JOIN tblLoan ON tblBorrower.[BorrowerID] = tblLoan.[BorrowerID]) INNER JOIN (tblBook INNER JOIN tblBookLoan ON tblBook.[BookID] = tblBookLoan.[BookID]) ON tblLoan.[LoanID] = tblBookLoan.[LoanID]) ON tblBookCategory.BookCategoryID = tblBook.BookCategoryID) ON tblBookType.BookTypeID = tblBook.BookTypeID) ON tblType.TypeID = tblBorrower.TypeID
WHERE (((tblBookLoan.DateDueBack)<Date()));

它在 Access 中运行良好并返回所需的记录。

但是，当我尝试使用查询向导在 Visual Studio 中运行相同的代码时，我收到以下消息：

"）"附近的 WHERE 子句中出现错误。无法分析查询文本。

我尝试删除括号，但似乎没有任何效果。

为什么它在 Access 中运行，而不是在 Visual Studio 中运行？