[AccessD] Connection String syntax

YOu can use Windows to create most connection strings -- I wonder if that
technique would apply here too?

Susan H.


 Carl Prothman has a site that provides ADO connection strings for a
> wide variety  of databases and providers. Even though he has
> switched over to the dark side.
>
> http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet
>
> If using a Workgroup (System Database)
>
> oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>            "Data Source=c:\somepath\mydb.mdb;" & _
>            "Jet OLEDB:System Database=MySystem.mdw", _
>            "myUsername", "myPassword"
>
>