I'm trying to create a linked
server to access an old MS Access
database (.mdb file) on SQL Server 2012
, but I always get the error 7399 (authentication denied). So I tested with another mdb file that has no password and, in this case, the linked server worked perfectly. I've already given all permissions to the file's folder.
I tried to deny the inprocess in the ACE.OLEDB driver, but, if I do that, I got a new error
7302 (SQL Server could not create a driver instance to this linked
server).
I can't see what I'm doing wrong. I've searched about this a lot, and I still didn't find out a solution.
Best Answer
The problem was the file. I got a Windows XP virtual machine that has the MS Access 95. So I could open the file to delete the current password and change groups permissions. Now the linked server works.
It seems neither Microsoft.ACE.OLEDB.12.0 nor Microsoft.Jet.OLEDB.4.0 can deal with MS Access 95 security policy. But I really don't know why.