Security clarification.

[dschomburg]

I have set groups and users with premissions and it works great. Now the issue I do not understand is, Everytime I open a new database (not the secured one) I now have to log in ? So all I have really done is to secure the Access application not the database.

Is this the way Access works, or am I missing something?

Any help would help a heap.
Thanks,
Dave Schomburg

 

[dschomburg]

Anyone?

 

[GeekGirlau]

Hi Dave,

Did you set up a new *.mdw workgroup file before you started? If not, Access has stored all your user and group information in the default system.mdw (located in your Windows System directory). This means that every database will now prompt you to log in.

It's a good idea to create a separate workgroup file for your application rather than using the default, and set up a shortcut for users that specifies the name and location of the workgroup file. You can create or join a workgroup file by running the Workgroup Administrator (WRKGADM.EXE in the Windows System directory).

Let me know if you need any further information - security can get rather involved X-)

 

[tlbroadbent]

Check the security topic in the FAQ area of this forum. faq181-83 is very good and points to a Microsoft Security FAQ that will guide you through the process of setting up Access security. It answers many security questions. Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous

 

[dschomburg]

Thank you all for your replies. I have created a .mdw file and joined the users to it. The database is on a shared network drive and I have not split it yet.

By "Joining" the new .mdw, shouldn't the system default remain? If I run WRKGADM.EXE to check which group I belong to, I only see the new group.

 

[tlbroadbent]

The default only remains the same when you join the workgrp via the command line option /wrkgrp. If you use the work group admin program to join a workgroup, that work group becomes your new default. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.

 

[dschomburg]

Oh! so you should set the workgroup thru code upon OnLoad or something like that.
Not just use the admin program in the System Directory.


Cool Thanks a heap
Can't wait to try it.

Dave

 

[tlbroadbent]

No. You set the work group with a command line option when you start Access. For example, the following command line starts Access and opens the accounts database using the acctsys.mdw work group file. This command line would be included in the shortcut used to start the application.

c:\program files\office\msaccess.exe /wrkgrp c:\data\accounting\actsys.mdw c:\data\accounting\accounts.mdb

The work group selection only applies to the current execution of Access when done this way. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.

 

[dschomburg]

Brilliant!!! Thanks again for all your help.