Re: How To Apply Security on Just ONE Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Amy wrote:
How can I make ONE database reuiqre user name and passwod and apply a
certain security?
We have mutliple Access databases in our network. I would like to
apply some security (Read-only for some users, Update/Insert
permission for some users, etc.) to ONE database, say Customer.mdb.
I created a workgroup file and other team members joined the
workgroup. Then, all team members were asked to input user name and
password even if they are trying to use other access databases which
do not require any security. How can I prevent this? How can I make
just one database ask user name and password?

Logging in is driven by the workgroup file, not the MDB being opened. If you
only want to be prompted when opeining a certain file then DON'T join the secure
workgroup. Stay joined to the default and use a shortcut for the secure one
with a target like...

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

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


.

Relevant Pages

  • Re: cmd MS Access 2003 macro security disable
    ... some Users will have as many as 500 MS Access Databases on their systems (no ... like it when Users have to go to Tools - Macros - Security to move the ... security to low everytime they get a new image or open my app. ... I have gotten this far on my .cmd prompt, but I keep getting errors and it ...
    (microsoft.public.access.modulesdaovba)
  • Re: logon Failure by Computer accounts in different domain ?
    ... Microsoft Access databases. ... Volunteers from all ... over the world answer questions about Access database security. ... My advice to you is to create a new account and tell all your contacts to ...
    (microsoft.public.access.security)
  • removing all security
    ... I was experimenting with security and user group ... permissions. ... I made a local copy of one of our access databases onto my local ...
    (microsoft.public.access.security)
  • Access wont create sysem.mdw file automaticlly or manually why?
    ... I can't create access databases because I keep getting cant find system.mdw file. ... Access won't create sysem.mdw file automaticlly or manually when I go to the security section and Try ... TIA ...
    (microsoft.public.access.setupconfig)
  • Access wont create sysem.mdw file automaticlly or manually why?
    ... I can't create access databases because I keep getting cant find system.mdw file. ... Access won't create sysem.mdw file automaticlly or manually when I go to the security section and Try ... TIA ...
    (microsoft.public.access.gettingstarted)