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 > >