[解决] The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".


In the SQL Server, try these steps:

Open one database.
Click in the option Server Object.
Click in Linked Servers.
Click in Providers.
Right click on Microsoft.ACE.OLEDB.12.0 and click Properties.
Uncheck all the options and close.