Using the following query to try to go from sql server 2012 (64bit) to Access 2003 (32bit). Same error message for Jet.4.0.
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Could not find installable ISAM.".
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)".
I have been to several blogs. I have already:
- Added permissions to dcom/com
-changed temp and tmp variable to c:\temp
-changed the user to a sysadmin (sql server level)
Banging head on keyboard - any help appreciated.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?