Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / July 2006

Tip: Looking for answers? Try searching our database.

Security workgroup file ....

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mikey C - 31 Jul 2006 13:44 GMT
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 :-)
Rick Brandt - 31 Jul 2006 13:48 GMT
> Hi guys!
>
[quoted text clipped - 6 lines]
>
> Thanks for your time :-)

The recommended way is to leave users joined to the default workgroup
System.mdw and then provide them with a shortcut that opens secured files
with a command line argument to specify the secured MDW file.  The target of
such a shortcut would have this format...

"Path to MSAccess.exe" /wrkgrp "path to secure MDW" "path to MDB"

That is also a good way to test that you applied security correctly.  When
joined to the default workgroup they should only be able to open your file
using the special shortcut.  If they can open it without using that then you
missed some steps.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Rick B - 31 Jul 2006 13:52 GMT
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

Signature

Rick B

> Hi guys!
>
[quoted text clipped - 6 lines]
>
> Thanks for your time :-)
Mikey C - 31 Jul 2006 16:40 GMT
Ah ha!

This worked a treat - cheers guys!

> Sounds like you had them join your workgroup - which will use it everytime
> the Access application is started.
[quoted text clipped - 39 lines]
> >
> > Thanks for your time :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.