different database use separate workgroup information file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I met a problem when I try to set the password for my databases:
I have two databases which are all on my shared network drive. I set two
different workgroup information files for each of them. Each works well when
testing separatly. The problem is that after I join one of the database to
its workgroup file, Access will automatically set this file as default
workgroup information file, and the other database will use same workgroup
information file when it is opened. My question is how can I make the
databases use different workgroup information files each time when they are
opened? For example, DB A uses file aa, DB B uses file bb. When I open DB B
after DB A is open, DB B should use file bb, not aa which is set as default
by the system after DB A is open.

Thanks very much!
 
Flora said:
Hi, I met a problem when I try to set the password for my databases:
I have two databases which are all on my shared network drive. I set
two different workgroup information files for each of them. Each
works well when testing separatly. The problem is that after I join
one of the database to its workgroup file, Access will automatically
set this file as default workgroup information file, and the other
database will use same workgroup information file when it is opened.
My question is how can I make the databases use different workgroup
information files each time when they are opened? For example, DB A
uses file aa, DB B uses file bb. When I open DB B after DB A is open,
DB B should use file bb, not aa which is set as default by the system
after DB A is open.
Click to expand...

Do not join either workgroup using the workgroup administrator. Leave your
computer joined to the standard system.mdw workgroup.

Create desktop shortcuts for your secure databases. You can specify the
workgroup to use for the session in the shortcut. The target would have
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
in it.
 
You need to create a shortcut to the database files and specify which MDW to use. For example...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\MDB\softwareinstallation.mdb" /wrkgrp "\\Ucscorpdata2\Shared\SIN\Secured\MDB\SECURE.mdw"



This shortcut runs my database where the front-end lives in C:\mdb and my worgroup file lives on the server at \\Ucscorpdata2\Shared\SIN\Secured\MDB\SECURE.mdw




Rick B



Hi, I met a problem when I try to set the password for my databases:
I have two databases which are all on my shared network drive. I set two
different workgroup information files for each of them. Each works well when
testing separatly. The problem is that after I join one of the database to
its workgroup file, Access will automatically set this file as default
workgroup information file, and the other database will use same workgroup
information file when it is opened. My question is how can I make the
databases use different workgroup information files each time when they are
opened? For example, DB A uses file aa, DB B uses file bb. When I open DB B
after DB A is open, DB B should use file bb, not aa which is set as default
by the system after DB A is open.

Thanks very much!
 
Next newbie question, when can I specify the path after I create the
shortcut? I only found one target field in the property of the shortcut which
specifies the database file location. Thanks a lot!
 
I figured out, Thanks!

Flora said:
Next newbie question, when can I specify the path after I create the
shortcut? I only found one target field in the property of the shortcut which
specifies the database file location. Thanks a lot!
Click to expand...
 
Back
Top