Nov 16, 2012 04:29 AM|Decker Dong - MSFT|LINK
As far as I see, I think you can take hans_v's idea.
My addition：We don't have syntax checks in VS directly. So you can：
1）Copy your SQL of Access into AccessDataBase's Query window to run to check whether it goes well or not. (Recommanded).
2）You can use LINQ-TO-ACCESS, this isn't supported by Microsoft but It can also directly support CRUD in Vs's syntax checking, just like LINQ-TO-SQL.
For more you can see this：