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 / Security / August 2004

Tip: Looking for answers? Try searching our database.

when users go around the form to update table directly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Laura Prendville - 20 Aug 2004 16:43 GMT
I'm in Access 2002.

I made a lovely form to update a timestamp and CurrentUser
field, but users are going around the form to update the
table directly.  

How can i get these fields to update if a user changes
data directly in the table?  I can't even get the
CurrentUser() to work in the table's default value.

I'm trying to migrate from Foxpro 2.6 to Access.  Due to
ISO standards, I can't roll my project out until I can
address this.

please help.  thanks.

-Laura
Joan Wild - 20 Aug 2004 17:28 GMT
> I'm in Access 2002.
>
> I made a lovely form to update a timestamp and CurrentUser
> field, but users are going around the form to update the
> table directly.

How are they even getting to the table?

> How can i get these fields to update if a user changes
> data directly in the table?  I can't even get the
> CurrentUser() to work in the table's default value.

No, that function won't work in a table.

You should:
Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
       set the startup form
       set your default menu (the custom one you made)
       disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
       hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item)
       Click on the Advanced button and uncheck the allow special keys
(this will disable the F11 key, among others)

If you need to bypass these startup features, you can hold the shift key
down while you open the db.  If you feel that your users may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).

Signature

Joan Wild
Microsoft Access MVP

 
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.