ADODB Connection String: Workgroup Information file is Missing?

ms-access passwords connection-string adodb
Mohgeroth picture Mohgeroth · Mar 16, 2010 · Viewed 33.7k times · Source

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?

Answer

Fionnuala picture Fionnuala · Mar 17, 2010

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

Related questions

How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Sum(tbl1.fld1 + tbl1.fld2) AS [Total] …

Read More
Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!

Read More