R
RSB7678
Can I automatically switch between workgroups created using MS Access?
I have created a workgroup with usermame and password . Another
workgroup (default).
When ever I open an Access database db1.mdb it should ask for username
and password. If I open any other Access database db2.mdb or db3.mdb or
db4.mdb etc. it should automatically open the database without prompting
for username and password.
I tried creating a shortcut for db1.mdb with target properties and
opending using this shortcut as below but no luck:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"B:\folder1\folder2\folder3\folder4folder4\data_model.mdb" / WRKGRP
"B:\folder1\folder2\folder3\folder4folder4\Security.mdw"
FYI, I have to do this on the network and 'm using MS Access 2003.
Thanks
RB
I have created a workgroup with usermame and password . Another
workgroup (default).
When ever I open an Access database db1.mdb it should ask for username
and password. If I open any other Access database db2.mdb or db3.mdb or
db4.mdb etc. it should automatically open the database without prompting
for username and password.
I tried creating a shortcut for db1.mdb with target properties and
opending using this shortcut as below but no luck:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"B:\folder1\folder2\folder3\folder4folder4\data_model.mdb" / WRKGRP
"B:\folder1\folder2\folder3\folder4folder4\Security.mdw"
FYI, I have to do this on the network and 'm using MS Access 2003.
Thanks
RB