Improve company productivity with a Business Account.Sign Up

x
?
Solved

How reset user permission??

Posted on 2001-09-04
3
Medium Priority
?
682 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 200 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

595 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