一个进销存管理连接access2007数据库的vb设计

wellhide 发布于 2012-04-04 23:44， 830 次点击

Public Function cnn() As ADODB.Connection
    Set cnn = New ADODB.Connection
    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\db_sss.accdb;persist security info=false;user id=sa;initial catalog=db_SSS"

End Function
看一下错误的地方

2 回复

Artless2012-04-05 00:27

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

wellhide2012-04-05 13:04

vb运行时黄线会停留在这一句cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\db_sss.accdb;persist security info=false;user id=sa;initial catalog=db_SSS
显示实时错误-2147217887多不oledb操作产生错误