Access In Built Security Group

[dan.cawthorne]

Hi All,

I'm wondering if some one could advise on where I'm going wrong with
the access inbuilt Security feature,

Ive created a work group for my front end database and I've created
all users that are needed and I've also created the desired groups.

So when a user opens the database the user has to sign in.

for extra Security I've been into the start up options and I've taken
the to tick out show database window.
I've also disabled the inbuilt menus and allow full menus tick and
also edit tool bars, so the user shouldn't be able to open the
database window.but sent the main menu form.

The front end database is located on a citrix remote server, and in a
shared folder, so ever one can access the front end, the citrix also
has its own copy of access intsalled on it. so the front end is opened
on the citrix.

the problem i have though, is that when i open the front end on some
else citrix login, The front end is defaulted to access default
security group, and I'm unable to join a new the Security Group i
created.

I'm also unable to convert the database front end into a MDE as it
says its to big to convert.

I've also tried to have a button Security work groups in a custom tool
bar i have created, but the user can easily assign a new work group.

 

[John W. Vinson]

the problem i have though, is that when i open the front end on some
else citrix login, The front end is defaulted to access default
security group, and I'm unable to join a new the Security Group i
created.

Use a Shortcut to open the database, and specify the workgroup file in its
command line:

"%ProgramFiles%\Office\Office11\msaccess.exe" "E:\SomePath\yourdatabase.mdb"
/wrkgrp "E:\Somepath\YourWorkgroupFile.mdw"


John W. Vinson [MVP]

 

[dan.cawthorne]

Use a Shortcut to open the database, and specify the workgroup file in its
command line:

"%ProgramFiles%\Office\Office11\msaccess.exe" "E:\SomePath\yourdatabase.mdb"
/wrkgrp "E:\Somepath\YourWorkgroupFile.mdw"

John W. Vinson [MVP]

Do I need to place the line command in the target box or the Start in
Box? in the short cut? The short cut icon is located in the following
folder "P:\EPM Enquiry Management System\

The current target box in as "P:\EPM Enquiry Management System\Epm
Enquiry Management System BackEnd\Epm Management System V1 Front
End.mdb"

and the current start in box is "P:\EPM Enquiry Management System\Epm
Enquiry Management System BackEnd\Epm Management System V1 Front
End.mdb"

the work group file is located in folder P:\EPM Enquiry Management
System\Epm Enquiry Management System BackEnd

so i tried the following in the tartget box

"P:\EPM Enquiry Management System\Epm Enquiry Management System BackEnd
\Epm Management System V1 Front End.mdb" "P:\EPM Enquiry Management
System\Epm Enquiry Management System BackEnd\System.mdw"

the data base opens ok but when i go to some else pc it dont open the
work group file at same time?

 

[John W. Vinson]

Do I need to place the line command in the target box or the Start in
Box? in the short cut? The short cut icon is located in the following
folder "P:\EPM Enquiry Management System\

The current target box in as "P:\EPM Enquiry Management System\Epm
Enquiry Management System BackEnd\Epm Management System V1 Front
End.mdb"

and the current start in box is "P:\EPM Enquiry Management System\Epm
Enquiry Management System BackEnd\Epm Management System V1 Front
End.mdb"

the work group file is located in folder P:\EPM Enquiry Management
System\Epm Enquiry Management System BackEnd

so i tried the following in the tartget box

"P:\EPM Enquiry Management System\Epm Enquiry Management System BackEnd
\Epm Management System V1 Front End.mdb" "P:\EPM Enquiry Management
System\Epm Enquiry Management System BackEnd\System.mdw"

the data base opens ok but when i go to some else pc it dont open the
work group file at same time?

It needs to be in the target box, and it needs to have the msaccess.exe (with
its appropriate path) specified at the beginning of the target in order for
the command line switches (like /wrkgrp) to work. Your reply does not in any
way whatsoever resemble what I suggested... Find msaccess.exe on your computer
(it will usually be in C:/Program Files/, for which %ProgramFiles% is a system
alias) but of course it could have been installed elsewhere. The

/wrkgrp <workgroup file name>

is an essential switch to tell Access which workgroup file you want to use.
You can't leave it out!

Does everyone have the P drive mapped identically? If not, you may want to use
the \\server syntax:

"%ProgramFiles%\Office\Office11\msaccess.exe" "\\servername\EPM Enquiry
Management System\Epm Enquiry Management System BackEnd\Epm Management System
V1 Front End.mdb" /wrkgrp "\\servername\EPM Enquiry Management System\Epm
Enquiry Management System BackEnd\System.mdw"

where servername is the name of the share mapped to the P drive.

John W. Vinson [MVP]

 

[dan.cawthorne]

It needs to be in the target box, and it needs to have the msaccess.exe (with
its appropriate path) specified at the beginning of the target in order for
the command line switches (like /wrkgrp) to work. Your reply does not in any
way whatsoever resemble what I suggested... Find msaccess.exe on your computer
(it will usually be in C:/Program Files/, for which %ProgramFiles% is a system
alias) but of course it could have been installed elsewhere. The

/wrkgrp <workgroup file name>

is an essential switch to tell Access which workgroup file you want to use.
You can't leave it out!

Does everyone have the P drive mapped identically? If not, you may want to use
the \\server syntax:

"%ProgramFiles%\Office\Office11\msaccess.exe" "\\servername\EPM Enquiry
Management System\Epm Enquiry Management System BackEnd\Epm Management System
V1 Front End.mdb" /wrkgrp "\\servername\EPM Enquiry Management System\Epm
Enquiry Management System BackEnd\System.mdw"

where servername is the name of the share mapped to the P drive.

John W. Vinson [MVP]

I feel like an idiot,

I didn't see the switch in the command line "/wrkgrp" in your origanal
reply,

Yes every ones remote server is mapped as an P:

I did Try Putting ""C:\Office\Office11\msaccess.exe" in front first,
as that is where the access is installed but i will try again.

Thank you for your patients

 

[dan.cawthorne]

I feel like an idiot,

I didn't see the switch in the command line "/wrkgrp" in your origanal
reply,

Yes every ones remote server is mapped as an P:

I did Try Putting ""C:\Office\Office11\msaccess.exe" in front first,
as that is where the access is installed but i will try again.

Thank you for your patients

Thanks Again John,

Ive Now Managed Get To Work,