Trouble connecting MS Access with linked Server from MS SQL

Daniel Niklaus
Daniel Niklaus used Ask the Experts™
on
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.

https://visakhm.blogspot.com/2013/12/how-to-solve-microsoftaceoledb120-error.html

https://social.msdn.microsoft.com/Forums/sqlserver/de-DE/96ca13a3-a39e-4271-aa93-86e20067544f/linked-server-error-7303?forum=sqldataaccess

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?
Comment
Watch Question

Do more with

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

Author

Commented:
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