When I try to connect to an Access database with no password, ADO
connects without a hitch.  When I try to connect to an Access databse
with a password it brings up the error "Workgroup Information File
missing or locked exclusively by another user".  I checked on Microsofts
website and it said the problem was in the System.MDW file in the
C:\Windows\System directory and to run MUSRMGR.EXE to properly setup the
file.  Well, I've tried this all a dozen times with no luck!  This
happens on multiple machines.  Has anyone run into this one before?

Thanks in advance,

Todd Brewer
Galton Technologies.

You must set the System Database property.

Assuming JET 4 as the provider and a UDL,

1)  Open the UDL for editing
2) Click the ALL tab
3) Select "Jet OLEDB:System database"
4) Click EDIT
5) Specify the path and filename to the MDW file.

Test the connection on the Connection panel.

Pierre

news:38AAFE8C.526FB8D6@galton.com...

You need to specify the system database location in your connection string

'Provider= Microsoft.Jet.OLEDB.4.0;
 & Data Source=\\MyComputer\MyShare\MyDatabase.mdb;
Jet OLE DB:System Database = \\MyComputer\MyShare\MySystem.mdw'
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com