Hi.
I looked through few pages of threads here, but didn't find the answer to my questions.
I'm writting a C# application (Windows Forms) that uses MSAccess database, and I have the following questions:
1. how can I check in what group the current user's is?
I created a login dialog box, and use the standard connection string to connect:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + database + ";Jet OLEDB:System Database=" + workgroup + "; User Id=" + login + "; Password=" + cm.GetPass()
but I want to enable some options only to given groups of users (say administrators). How can I do that? Is there an easy way to check that?
2. I have problems with creating workgroups. An unsecured db works fine, but when I create a workgroup, I cannot log onto the db because non of the users have nay rigths (Unfortuantely I must use office 2000).
In MSAccess:
I create another user (root), and give him full admin rights. Then I log as root and revoke all rights from the base admin.
I create other users, and grant them some priviligies.
I create a workgroup file and when the db is secured non of the users has any rights nor to the database, nor the workgroup (mdw file). Of course, I cannot log into the db from my C# application.
Could you guys help me with that (I know, this is probably not the place for the second question, but I didn't want to create two threads)?