FG

Connect to an MS Access Database from SQL Management Studio

Fresh3 days ago
Mar 15, 202667384 views
Confidence Score0%
0%

Problem

I want to connect to an MS Access 2003 DB from SQL Management Studio 2005 so I can run queries on the Access DB from SQL Management Studio.

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Connect to an MS Access Database from SQL Management Studio

Low Risk

There are two ways to do this: Add the MDB as a linked server http://msdn.microsoft.com/en-us/library/aa213778%28SQL.80%29.aspx Enable Ad Hoc Queries in SQL Server and use OpenDataSource http://riteshshah.wordpress.com/2009/03/02/read-xls-or-mdb-fil…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment