Creating a custom user environment

[Kevin Henning]

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]

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...ss+bypass+shift&rnum=4&hl=en#efdeb1dad6e2bef9


User-Specific Forms...
http://groups-beta.google.com/group...exec+user+forms&rnum=4&hl=en#a35305f4d737266e


Similar post on User Forms...
http://groups-beta.google.com/group...xec+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...wner+permission&rnum=4&hl=en#0dff4a869a52df72



And one more...
http://groups-beta.google.com/group...ner+permission&rnum=61&hl=en#753a4ec9bcb39700