Create Database joining specific mdw

[micsak]

I want to create from My Access application another database linking in specific mdw and set specific permissions and denies to each user.

Let's say I have c:\Myfile.mdb and c:\mysystem.mdw and I want to create database NewFile.mdb
When we open the "NewFile.mdb I want all permissions have already been settled by my first application.

Can you help me?

Regards
Michael

 

[Autoeng]

The same security work file can be used across several db's. If you will notice that you access the original db through a shortcut that joins the appropriate workgroup. Note however that the .mdw file only contains the users allowed in the db. You will still have to setup security within the db so that different access levels are given to your particular forms, reports, tables, queries. ect.. Therefore you can use the same .mdw file to specify users but not their access to objects within the db. You have to set that up individually for every db.


Shortcut examples
"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "c:\myfile.mdb" /wrkgrp "c:\mysystem.mdw"

So if you want to use the same workgroup for c:\newfile.mdb just create a copy of the shortcut and alter the target to:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "c:\newfile.mdb" /wrkgrp "c:\mysystem.mdw"

 

[micsak]

Many Thanks. So the first part is solved.
The second problem - I want to make permissions not from within new db database (newfile.mdb) but I want to give the permissions from my initial database myfile.mdb via vba .

Can you help me on this also?

Thanks
Michael

 

[Autoeng]

I think you would be much better off with custom security. Member Mission2Java has much more experience with custom security scenerios than I so hopefully he'll see this post and reply. You could try to PM him but I don't know if he has that turned on or not.

Good luck.