Has anyone had any experience in administering an Access workgroup file from within VB 2005 or VB.Net ? I appreciate the direction. Thanks Paul
Hello Paul. Paul Ilacqua wrote: > Has anyone had any experience in administering an Access workgroup > file from within VB 2005 or VB.Net ? I appreciate the direction. Although I have no experience with that in .Net, I guess that the easiest way will be through the DAO library (a COM component). Set the SystemDB property of the DBEngine object to the path of your workgroup file and then use the CreateWorkspace method to "log in" as a member of the admins group and manage Users and Groups through the collections of the workspace object. -- Regards, Wolfgang
Thanks Wolfgang.... I appreciate the response... I'll give it a whirl. Sad part is in VB6 this can be done in 5 minutes. Paul "Wolfgang Kais" wrote in message news:u0KpWG#1IHA.5048@TK2MSFTNGP06.phx.gbl... > Hello Paul. > > Paul Ilacqua wrote: >> Has anyone had any experience in administering an Access workgroup >> file from within VB 2005 or VB.Net ? I appreciate the direction. > > Although I have no experience with that in .Net, I guess that the > easiest way will be through the DAO library (a COM component). > Set the SystemDB property of the DBEngine object to the path of your > workgroup file and then use the CreateWorkspace method to "log in" as > a member of the admins group and manage Users and Groups through the > collections of the workspace object. > > -- > Regards, > Wolfgang > >
Hello Paul. Just add the reference to the COM library (DAO). Then, why should it take longer than the 5 minutes in VB6? -- Regards, Wolfgang "Paul Ilacqua" wrote: > Thanks Wolfgang.... > I appreciate the response... I'll give it a whirl. Sad part is in VB6 this > can be done in 5 minutes. > Paul > > "Wolfgang Kais" wrote in message > news:u0KpWG#1IHA.5048@TK2MSFTNGP06.phx.gbl... >> Hello Paul. >> >> Paul Ilacqua wrote: >>> Has anyone had any experience in administering an Access workgroup >>> file from within VB 2005 or VB.Net ? I appreciate the direction. >> >> Although I have no experience with that in .Net, I guess that the >> easiest way will be through the DAO library (a COM component). >> Set the SystemDB property of the DBEngine object to the path of your >> workgroup file and then use the CreateWorkspace method to "log in" as >> a member of the admins group and manage Users and Groups through the >> collections of the workspace object. >> >> -- >> Regards, >> Wolfgang >> >>
