ADODB 连接字符串：工作组信息文件丢失？
我有一些正在访问的数据源，我需要以编程方式连接到这些数据源，以便在幕后进行操作并保持用户的可见性。
所述数据源有一个密码“pass”，我将在这里称呼它。使用此连接方法，尝试使用打开方法时出现错误
Dim conn as ADODB.Connection
Set ROBBERS.conn = New ADODB.Connection
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=\\pep-home\projects\billing\autobilling\DPBilling2.mdb;" _
& "Jet OLEDB:Database Password=pass;", "admin", "pass"
“无法启动您的应用程序。工作组信息文件丢失或已被其他用户独占打开。”
由于计划进入 2007 年，我们现在不再使用也从未使用过通过访问访问的工作组标识文件。数据源上的数据库密码是通过“设置数据库密码”设置的，该密码必须在独占打开时完成。
我花了很长时间改变我的连接选项，在哪里放置密码等，要么找不到正确的格式，要么（为什么我在这里问）我认为可能还有一些其他未知的东西我必须设置才能做到这一点。有人得到一些有用的信息吗？
I have a few data sources in access that I need to connect to programatically to do things with behind the scenes and keep visibility away from users.
Said datasource has a password 'pass' as I'm going to call it here. Using this connection method I get an error attempting to use the open method
Dim conn as ADODB.Connection
Set ROBBERS.conn = New ADODB.Connection
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=\\pep-home\projects\billing\autobilling\DPBilling2.mdb;" _
& "Jet OLEDB:Database Password=pass;", "admin", "pass"
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
Due to planning to move into 2007, we are not using nor have ever used a workgroup identification file through access. The database password on the data source was set through the Set Databa Password which had to be done on an exclusive open.
Ive spent a good while changing around my connection options, where to put the passwords etc and either cannot find the right format, or (why I'm asking here) I think there may be some other unknown that I must setup to do this. Anyone out there got some useful information?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您的连接字符串似乎不正确。尝试：
-- http://www.connectionstrings.com/access
Your connection string seems to be incorrect. Try:
-- http://www.connectionstrings.com/access