I was trying to create a live link to access database using Access Linked Server;
SSMS version 19.3
Office 365
Please help to resolve this error:
The script Used;
EXEC sp_addlinkedserver
@server = 'AccessLinkedServer', -- The name of the linked server
@srvproduct = '', -- Product name (leave blank for Access)
@provider = 'Microsoft.ACE.OLEDB.16.0', -- The OLE DB provider for Access
@datasrc = 'C:NESTNEST Bill Temp_be.accdb'; -- The path to the Access database file
— Test the linked server connection
SELECT * FROM OPENQUERY(AccessLinkedServer, 'SELECT * FROM RGEtblPromotions').
Error:
Msg 7403, Level 16, State 1, Line 17
The OLE DB provider “Microsoft.ACE.OLEDB.16.0” has not been registered.
Not sure what else I need to do. Looking forward to your help asap
Microsoft Access database Engine 2016 (64 & 32 bits have been installed)
Tried to register Microsoft.ACE.OLEDB.16.0 through command window. Error agin