Hi

I'm trying to open the following ADO Connection


Dim conn as adodb.connection

Conn.Open "Provider=Microsoft.Jet.OleDb.3.51;Datasource=C:\program files\sm2000\databases\maindb.mdb", "", "anchor"

where anchor is the password, I've tried putting Admin in for user or leaving that part blank as above

Either way I get the error

"Can't start your application. The workgroup information file is missing or opened exclusively by another user"

This is a stand alone computer so noone else is accessing the db

I have no problem opening non password protected databases and the database in question opens fine in DAO

any ideas would be appreciated

Mark