ADODB连接字符串:工作组信息文件丢失? [英] ADODB Connection String: Workgroup Information file is Missing?

问题描述

我需要访问一些数据源，这些数据源需要以编程方式连接到后台，以便在后台进行操作并保持可视性，使用户无法看到.

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.

所说的数据源有一个密码"pass"，我将在这里称它为"pass".使用这种连接方法时，尝试使用打开方法时出现错误

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."

由于计划进入2007年，我们没有使用，也从未使用过通过访问使用过的工作组标识文件.数据源上的数据库密码是通过设置数据库密码"设置的，该密码必须以独占方式打开.

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?

推荐答案

您的连接字符串似乎不正确.试试:

Your connection string seems to be incorrect. Try:

conn.open "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=\\pep-home\projects\billing\autobilling\DPBilling2.mdb;" _
& "Jet OLEDB:Database Password=MyDbPassword;"

- http://www.connectionstrings.com/access

这篇关于ADODB连接字符串:工作组信息文件丢失?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！