Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 2
Cannot get the column information from OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)".
There are multiple reasons and multiple solutions to this problem. I will explain all the ones that I found while researching on the net and which together helped me to solve mine
First you need to check whether you have installed the 2007 Office System Driver: Data Connectivity Components which is necessary for Microsoft OLEDB ACE 12.0 driver to work. So if you have not done that download it by clicking the link below.
2007 Office System Driver: Data Connectivity Components
Once you downloaded and installed it on your system restart your machine to see if the issue is resolved for you or not.
Check whether the user login that you are accessing has rights on SQL Server Service or not. If not you will have to give your credentials so that the SQL Service runs using your login credentials.
1. Close SQL Server Management Studio. Type Services.msc in the run command to open the services window
2. Search for SQL Server Service and right click it and select properties as shown below
3. In the Log On Tab, select This Account. Click on Browse and type your login name there and the click on Check Names
4. Once it finds your login name press OK.
5. Now type your login’s passwords in both the fields as shown below press apply and then ok
6. Restart the services so that the new changes are applied as shown in figure below.
7. Now start SQL Server Management Studio and try to run the query if still not working try a system restart
Run the following Query in your SQL Server Management Studio close it and start again
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
I tried all of the above three solutions to get rid of the above error of which the first one is necessary
If any has some other solution that helped him solve the issue please share