?
Solved

How reset user permission??

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

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…
Suggested Courses

621 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