Home Forums SQL Server 2008 SQL Server 2008 - General Linked server with MS access mdb database - Error 7416? RE: Linked server with MS access mdb database - Error 7416?
terry999
SSCertifiable
Points: 5029
More actions
July 31, 2014 at 3:20 am
#1733960
Hi
Never used access, but had problem with Excel file on another machine. I had to set the user in the linked server properties to connect to the XLS as "admin".