Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to create a linked server to an 32 bit 2010 access database inside of SQLEXPRESS 2008 R2 64bit. Everything I've read has pointed me at the download : Access Database Engine

I've downloaded the 32 bit version (64 bit tells me my office is 32 bit) and installed it; however, the drop down in SQLEXPRESS > Create New Linked Server does not come back with an option for Microsoft Office 12.0 Access Database Engine OLD DB Provider.

I tried createing the linked server via sp_createlinkedserver but when I run a test connection on that server I get the error

OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode. (Microsoft SQL Server, Error: 7308)

Does this mean that it found the driver I needed? If so how do I get it to run with the linked server?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

For a 64bit build of SQL to use the Access drive you'll need to install the 64bit version of the Access drive. If you have the 32bit version of Office installed you'll need to either remove that and install the 64bit version of office or uninstall the 64bit build of SQL and install the 32bit build.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.