连接字符串MS Access 2013 [英] Connection String MS Access 2013
问题描述
我使用provider = Microsoft.ACE.Oledb.12.0; Data Source = Database1.accdb从VB.net连接到Access 2010但它在2013年不起作用。请告诉我如何???
I used "provider=Microsoft.ACE.Oledb.12.0;Data Source= Database1.accdb" to connect from VB.net to Access 2010 but it doesn't work on 2013. Please tell me how ???
推荐答案
嘿,
使用此字符串可能很有用:
hey,
maybe its useful to use this constring:
string conStr = "Provider=Microsoft.ACE.Oledb.14.0;Data Source=Database1.accdb; [Some Other Options=etc.;]";
for Office 2010
或者这个:
for Office 2010
or this:
string conStr = "Provider=Microsoft.ACE.Oledb.15.0;Data Source=Database1.accdb; [Some Other Options=etc.;]";
Office 2013
i知道如果你使用Windows 7就可能发生这种情况(64位)和Office 2010(例如),
你需要安装它e2010办公系统驱动程序数据连接组件(< -google for it - 32或64位可用)。
但我实际上并没有发现这样的2013年的办公室组件,所以也许旧的2010组件也可以在2013年运行。
顺便说一句,据我所知,JET引擎自2007年以来不再受支持;)
greetz,me
for Office 2013
i know that its could happen if you use windows 7 (64 bit) and office 2010 (for example),
that you need to install the "2010 office system driver data connectivity components" (<-google for it - 32 or 64 bit available) too.
but i didn't find actually such "office components" for 2013, so perhaps the "old" 2010 components works also on 2013.
by the way, as far as i know the JET-engine is no more supported since/for office 2007 ;)
greetz, me
创建并连接到asp.net中的访问数据库 [ ^ ]
尝试使用喷气发动机。
http:// www。 connectionstrings.com/access [ ^ ]
以下参考书签: http://www.connectionstrings.com/ [ ^ ]
Try using the jet engine.
http://www.connectionstrings.com/access[^]
For future reference bookmark this: http://www.connectionstrings.com/[^]
这篇关于连接字符串MS Access 2013的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!