Security workgroup file ....

M

Mikey C

Hi guys!

I have shared my database on a number of networked pc's and set-up
usergroups to control access to certain objects (database has also been
split). However, now that I have distributed the front-end to
colleagues, my security file has been set to apply to all other
databases on their / my computers. Can anybody tell me how I get this
file to apply only to this individual database?

Thanks for your time :)
 
R

Rick B

Sounds like you had them join your workgroup - which will use it everytime
the Access application is started.

Instead, leave them joined to their default workgroup and create a shortcut
for your database. In that shortcut, include the workgroup file to use.

This is all outlined in the various security FAQs that are available. You
should probably look these over. You might also verify that security is
REALLY in place. You might have one of your users join their default
workgroup file and try to open your file. If everything is set up properly,
then they should get an error and not be able to open the file at all.

Here are some good Security links:

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
M

Mikey C

Ah ha!

This worked a treat - cheers guys!

Rick said:
Sounds like you had them join your workgroup - which will use it everytime
the Access application is started.

Instead, leave them joined to their default workgroup and create a shortcut
for your database. In that shortcut, include the workgroup file to use.

This is all outlined in the various security FAQs that are available. You
should probably look these over. You might also verify that security is
REALLY in place. You might have one of your users join their default
workgroup file and try to open your file. If everything is set up properly,
then they should get an error and not be able to open the file at all.

Here are some good Security links:

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
Click to expand...
 
Top