Accessing a Jet Database with User level Security using ADO

[MarieT]

Hello,

I have a Microsoft Access Database 2000 that is secured with a Workgroup
file. I learned from Microsoft's Article ID 198755 how to determine who is
logged on to a Database using ADO and Microsoft Jet UserRoster. However,
since my databse is secured with a Workgroup file, I have had a hard time
making the cn.Open string work.
How do I include the workgroup file in the connection string? I have tried
several ways and kept getting an error "Run-time error
'-2147217843(80040e4d)' Cannot start your application The workgroup
information file is missing or opened exclsively by another user." One of
the ways I tried follows:
cn.Open "Data Source=C:\Northwind.mdb /WKGRP C:\Secured.mdw;User
Id=MarieT;Password=pass"
This assumes that my Northwind database is in \C: as well as my workgroup
information file \C:Secured.mdw.

Any help will be greatly appreciated.

Thanks,

Marie

 

[Douglas J. Steele]

Try:

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Northwind.mdb;" & _
"Jet OLEDB:System Database=C:\Secured.mdw", & _
"MarieT", "pass"

 

[MarieT]

It works!

Thank you so much Doug for your help and quick response!

MarieT