I have tried to use an MSAccess.mdb table linked to a SharePoint list and it did not work.
I have created new grid web component from Gird with Updatable Details template (SQL).
I used SQL database source and successfully connected to an mdb file table linked to SP list in.
However I could not see the fields of the table, and when I tried to select primary key I got this OLE error
OLE Error.jpg