User Level access to a specific database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been through a length tutorial to get me up and running with user
level security. But all it seems to have achieved is the allowing of
different users to start up access on my PC. What I actually want is to
secure one specific database only with user level security ie when they open
the database file it prompts them for a User name and passord. For all other
databases I don't want this to happen. Is this possible? I also want a log
file updated that logs the time the User opens and closes the database - is
this possible??

Thanks in advance.
 
You need to look at the Microsoft Security FAQ (you can find a copy here: http://www.rogersaccesslibrary.com/knowledge.html). Your problem is that you used the default MDW file (SYSTEM.MDW) or you joined the workgroup file with System.mdw via the Workgroup Admin tool. You should do neither of these things.

You want to create a workgroup file named similarly to your application (with the mdw extension, of course) and then you need to create a shortcut on the desktop that opens the database AND provides the correct workgroup information (there's a command line switch for it). Something like this:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" C:\Research\SecResearch.mdb /wrkgrp C:\Research\Research.mdw"

Anyone who tries to open it without the shortcut will fail. Anyone who opens it with the shortcut will have to log in. Also, BE SURE to give the default Admin user MINIMUM rights.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top