It seems that Microsoft created ____ for a lot of people trying to migrate applications to 64-bit platforms that use an Access database. My situation: need to create linked server in SQL Server Express 2008 R2 to an Access 2007 database.
The provider "Microsoft.ACE.OLEDB.12.0
" might work but is not listed as one of the available providers in the linked servers properties dialog. I have office 2007 installed on the machine, so I can't install the 2010 access database engine.
Can I somehow make the Microsoft.ACE.OLEDB.12.0
provider avialable on my system in this circumstance?
View Complete Post