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 / Database Design / April 2005

Tip: Looking for answers? Try searching our database.

Creating a custom user environment

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin Henning - 26 Apr 2005 19:22 GMT
I am trying to create a database that will allow users to login and go right
to a form customized for them. They should only be able to modify data on
their form, and no one else's. Any ideas?
Rick B - 26 Apr 2005 19:38 GMT
Set up User-Level security so everyone has to log in.
Turn off the database window on startup and turn off the bypass.
Create an autoexec macro that opens the form based on their UserID.
Only give them access to their forms.  You will also have to take away
access from the table and the query if your users are smart enough to try to
go around you and open them directly.

The following links might help...

Bypassing shift key...
http://groups-beta.google.com/group/microsoft.public.access/browse_thread/thread
/f03ffccf6a008452/efdeb1dad6e2bef9?q=microsoft.public.access+bypass+shift&rnum=4
&hl=en#efdeb1dad6e2bef9


User-Specific Forms...
http://groups-beta.google.com/group/microsoft.public.access.formscoding/browse_t
hread/thread/29248b5452b3ba61/a35305f4d737266e?q=microsoft.public.access+autoexe
c+user+forms&rnum=4&hl=en#a35305f4d737266e


Similar post on User Forms...
http://groups-beta.google.com/group/microsoft.public.access.forms/browse_thread/
thread/364390a9c1b66a49/df1702f0858b3e7f?q=microsoft.public.access+autoexec+user
+forms&rnum=19&hl=en#df1702f0858b3e7f


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

Security White Pages...
http://support.microsoft.com/?id=148555

A post on taking away access to the table, but still allowing updates
through a form...
http://groups-beta.google.com/group/microsoft.public.access.security/browse_thre
ad/thread/10894bd14de2d95a/0dff4a869a52df72?q=microsoft.public.access+query+run+
owner+permission&rnum=4&hl=en#0dff4a869a52df72


And one more...
http://groups-beta.google.com/group/microsoft.public.access.gettingstarted/brows
e_thread/thread/6f017cd2870defdf/753a4ec9bcb39700?q=microsoft.public.access+quer
y+run+owner+permission&rnum=61&hl=en#753a4ec9bcb39700


Signature

Rick B

> I am trying to create a database that will allow users to login and go right
> to a form customized for them. They should only be able to modify data on
> their form, and no one else's. Any ideas?
 
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.