How to Manipulate Uses and Groups (MS Access) in VB.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger.Smith - 10 Dec 2004 15:33 GMT

I am looking for samples or documentation that can help me to add new users
and groups a secured MS Access MDB. I need to be able to create new groups,
then assign table-level permissions to the group. Then I need to be able to
create new users (with passwords) and add each user to verious groups. If
anyone knows how to do this or where some documentation is, please let me
know.

Thanks,

Roger

Reply to this Message

Chris Jobson - 10 Dec 2004 18:44 GMT

I think you need to use ADOX, which isn't directly supported by .NET but can
be used via COM. See
http://www.eggheadcafe.com/forums/ForumPost.asp?ID=15611&INTID=14 for an
example of how to use ADOX from .NET, and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/adms
cadoxfundamentals.asp
for details of ADOX. (in particular the User and Group objects).

Chris Jobson

>I am looking for samples or documentation that can help me to add new users
>and groups a secured MS Access MDB. I need to be able to create new
[quoted text clipped - 6 lines]
>
> Roger

Reply to this Message

Roger.Smith - 10 Dec 2004 20:00 GMT

Thanks Chris. I searched for hours and only found examples of VB. (most of
what you referenced only had VB 6.0 examples) However, I found a sample or
two that was .NET and they said to add ADOX as a reference, and to use the
COM version. I figure that the COM version is the only version, because I
am unable to locate a .NET version of the class through my development
environment.

Thanks for the assistance....

Roger

>I think you need to use ADOX, which isn't directly supported by .NET but
>can be used via COM. See
[quoted text clipped - 15 lines]
>>
>> Roger

Reply to this Message

How to Manipulate Uses and Groups (MS Access) in VB.NET

Free Magazines