From within SQL Server, I have successfully created a linked server to an Access 2010 database, which I know because the "Test Connection" button says I am successful whenever I press it.
However, when I attempt to look at the tables in the catalogue, I get an access-denied error (see screenshot below). Would this error have to do with a Trust-Center setting in Access, or something else? I have tried changing the settings in the trust center, putting them at their least restrictive setting; but nothing has defeated the error message. Any expert advice?