access µ¼Èë SQL µÄÎÊÌâ

»·¾³£º

Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services ¿Í»§¶Ë¹¤¾ß 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Êý¾Ý·ÃÎÊ×é¼þ (MDAC) 6.1.7600.16384 (win7_rtm.090710-1945)
Microsoft MSXML 3.0 5.0 6.0 
Microsoft Internet Explorer 8.0.7600.16384
Microsoft .NET Framework 2.0.50727.4927
²Ù×÷ϵͳ 6.1.7600

SQL code:


EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@srvproduct = 'OLE DB Provider for ACE',
@datasrc = 'E:\Program Files (x86)\Microsoft Office\Templates\2052\Access\Northwind.accdb'
GO


exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

GO
SELECT * from OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'D:\A_B.mdb';
'admin';'',C)
GO


ÏûÏ¢ 7302£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÎÞ·¨´´½¨Á´½Ó·þÎñÆ÷ "(null)" µÄ OLE DB ·ÃÎÊ½Ó¿Ú "Microsoft.ACE.OLEDB.12.0" µÄʵÀý¡£




ÊÇ64λµÄwin7+SQL2008

ÄÜ°ïСµÜ½â¾öÁË£¬ ²»Ê¤¸Ð¼¤¡£

---

accessÊÇ2007Âð

---

( ¡Ño¡Ñ )ÍÛ£¬ÊÇÄãѽ£¡

ÄãÌ«ËÙ¶ÈÁË°É¡£

ÊÇ°¡£¬64λµÄ win7

---

Northwind.accdb

2003µÄ²»½ÐÕâ¸öÃû°É¡£

---

ÒýÓÃ