two database, two workgroups

[Guest]

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?

 

[Rick Brandt]

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"

 

[Guest]

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?