[AccessD] System MDW

MartyConnelly martyconnelly at shaw.ca
Mon Feb 17 01:28:01 CST 2003


When you install the MDAC . There should be a file called ado260.chm 
depending on MDAC version.

John W. Colby wrote:

>On a related note, is there anyway to access the help for the adox stuff?
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>-----Original Message-----
>From: accessd-admin at databaseadvisors.com
>[mailto:accessd-admin at databaseadvisors.com]On Behalf Of John W. Colby
>Sent: Sunday, February 16, 2003 10:31 PM
>To: AccessD
>Subject: [AccessD] System MDW
>
>
>Does anyone know how to get the path to the system mdw?
>
>Actually let's back up.  I need to create a new encrypted, password
>protected database.  One way to do that (using A2K / ADO) is to use the adox
>library as follows:
>
>    Dim cat As New ADOX.Catalog
>    Dim strDataSrc As String
>    strDataSrc = "c:\New.mdb"
>    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>                "Data Source=" & strDataSrc & ";" & _
>                "Jet OLEDB:Encrypt Database=True;"
>    cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>                            "Data Source=" & strDataSrc & ";Jet OLEDB:System
>database=" & _
>                            "C:\Program Files\Microsoft
>Office\Office\SYSTEM.MDW"
>    cat.Users("Admin").ChangePassword "", "password"
>
>As you can see the activeconnection property is looking for the path to the
>mdw.  Since this is going to run on YOUR system I have no idea where this is
>so... how do I find it?
>
>Or is ther an easier way?
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>----------------------------------------------------
>Is email taking over your day?  Manage your time with eMailBoss.
>Try it free!  http://www.eMailBoss.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>----------------------------------------------------
>Is email taking over your day?  Manage your time with eMailBoss.  
>Try it free!  http://www.eMailBoss.com
>  
>





More information about the AccessD mailing list