Trouble connecting MS Access with linked Server from MS SQL

Daniel Niklaus
Daniel Niklaus used Ask the Experts™
I tried to connect an MS Access with the linked server from MS SQL Server and got stuck with a 7303 error. According to the different blogs, I found it is most probably a permission problem.

After trying those tips, I still have a 7303 error.

The test connection works, as long as I don't try to view all the tables. I installed Microsoft.ACE.OLEDB.12.0 and 16.0. None worked.

Any ideas for the next step?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use dynamic parameter and allow inProcess


and used "run as administrator"!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial