Connecting from 64bit SQL Server to 32 bit Access DB


  • Hello,

    Using the following query to try to go from sql server 2012 (64bit) to Access 2003 (32bit).  Same error message for Jet.4.0.

    SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0', '\\**\**\**\**\**\**\**\**\NightlyProcessing\csniweb.mdb',tblUnits_National);

    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.



    Wednesday, October 30, 2013 8:51 PM


All replies