All geek questions in one place

ADODB Connection String: Missing Workgroup Information File?

I have several access data sources that I need to connect to the software in order to do things behind the scenes and maintain visibility from users.

The mentioned data source has a password "pass", as I am going to call it here. Using this connection method, I get an error when trying to use a public 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"

"The application cannot be started. The workgroup information file is missing or opened exclusively by another user."

Due to the planning for the transition to 2007, we do not use and did not use the workgroup identification file through access. The database password in the data source was set using the Set Databa password, which was to be executed at an exclusive opening.

Ive , .., , ( ). , - , . - ?

+3
1

. :

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

+13

Source: https://habr.com/ru/post/1737242/

More articles:


All Articles