|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
two database, two workgroupsGood afternoon,
Currently I have one database with 12 users and one workgroup for them. It works well. Right now, I need to design another new database with totally different 8 users. Does Access allows you to do that - two different database and two workgroups? -- sally sally wrote:
> Good afternoon, You can only have one workgroup at a time as your default, but you can create > > Currently I have one database with 12 users and one workgroup for > them. It works well. Right now, I need to design another new > database with totally different 8 users. Does Access allows you to > do that - two different database and two workgroups? and use as many workgroups as you want. The usual advice is to leave System.mdw as everyone's default and then use shortcuts that specify different workgroup files as command line arguments as needed for particular secured files. "path to MSAccess.exe" /wrkgrp "path to MDW" "path to MDB" -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thank you Rick.
Here is what I plan to do. 1. For the 2nd new database, open the database and create a new workgroup. This new db will be at different location and I will create a shortcut for users to access to it. It won't use default system.mdw. Is it doable? If so, while I am setting all this up, is it going to affect my current db and create problems? -- Show quoteHide quotesally "Rick Brandt" wrote: > sally wrote: > > Good afternoon, > > > > Currently I have one database with 12 users and one workgroup for > > them. It works well. Right now, I need to design another new > > database with totally different 8 users. Does Access allows you to > > do that - two different database and two workgroups? > > You can only have one workgroup at a time as your default, but you can create > and use as many workgroups as you want. The usual advice is to leave System.mdw > as everyone's default and then use shortcuts that specify different workgroup > files as command line arguments as needed for particular secured files. > > "path to MSAccess.exe" /wrkgrp "path to MDW" "path to MDB" > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > 
Other interesting topics
disallow import from another mdb database
Why bother securing? Why are all access database I open asking for log on? Security-Is there a better way? Help with an IF statement for the groups Need help with security Security permissions to convert the database Load Form Based on Current User's Group Need help securing an application with detail records Wizard Issues |
|||||||||||||||||||||||
