Solved

How reset user permission??

Posted on 2001-09-04
3
632 Views
Last Modified: 2013-12-05
I have one mdb and with 3 different mdw file(permission file). If i create another new mdb to insert/update some data into that mdb in different mdw. In my code i need to reassign again the permission to that mdb according to individual mwd right??? How can i do in my code????

Does anyone know how to solve this problem???
0
Comment
Question by:jetyun
3 Comments
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6453606
I am not sure if I understand you're question clearly.  Cant you just link to a main table containing users and permissions for each DB?  Then you would only have to ever worry about keeping one table updated.
0
 
LVL 1

Accepted Solution

by:
frankylew earned 100 total points
ID: 6455228
//////////////////////
Easy Tracking
//////////////////////

Try this:

1. Goto C:\Program Files\Microsoft Office\Office\1033 and run WRKGADM.EXE
2. Choose 'Join' and specify which mdw workgroup file you wanna use for your new mdb file.
3. Exit

One must be noted that upon the joining of any mdw wg file, all your database (mdb) 's access rights will be based on the this assignment.

Hope it helps.
Cheers.
0
 

Author Comment

by:jetyun
ID: 6474814
this is not what i want.....anyway, thanx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now