连接到MS Access MDB [英] connection to MS access mdb

问题描述

我通常可以通过VBA与Visual Studio 2005和VS 2008进行连接，而不会出现问题
ms访问权限是2003还是2008
但是当我购买一台新笔记本电脑时，它是64位的，之后我无法连接到数据库，并且出现错误提示，然后我更新了Office2007.
在Office帮助中，我发现我应该使用Service Pack 8安装Microsoft Jet 4.0，
但我找不到适用于62位的正确Service Pack，我的计算机上有Windows 7

i usually connect from VBA and visual studio 2005 and VS 2008 without problem
ms access is 2003 or 2008
but when i bought a new laptop , it is 64 bits ,and after that i could not connect to database , and there is and error raise , then i update office 2007 .
in office help i found that i should install Microsoft Jet 4.0 with Service Pack 8 ,
but i could not found correct service pack for 62 bit , my computer has windows 7

推荐答案

此处是问题:Microsoft摆脱了64位平台上的Jet的连接在64位平台上使用:

Provider = Microsoft.ACE.OLEDB.12.0;数据源= C:\ myFolder \ myAccess2007file.accdb; Persist Security Info = False;

那就是它甚至支持Access 2003的新驱动程序.

Here is thing : Microsoft is getting rid of Jet on 64 bit platform to connect on 64 bit platform use:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

That is the new driver it even supports Access 2003

First google hit[^]. What did you try ?

这篇关于连接到MS Access MDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！