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.