I have designed an application in Access 2000 which works as an electronic logbook. This application
contains two features:
(1) to prevent the operator from changing a record which has been saved for over 3 minutes and there is a customized "Save" button
on the form. The VBA module to perform this function works perfectly.

(2) to prevent the operator to go through backdoors to modify the table records. For example, I don't want the operator to select
"Window>Hide/Unhide..." option to open the table.
   (2.1) which implementation is easier and effective, hidding tables or  hidding the menulbar (or some of the options within the
menubar)?
   (2.2) do I still have to implement access user-level security feature after implementing the solution for (2.1) mentioned above? 

Thanks a million in advance,

Bill. 

Hi all, I have found that if I deselect all check-boxes, which reference to "menu bar", in the "Tools>Startups..." will hide all
the menu bar items except a customized menu I created called "Reports". Also, right-click on the mouse won't redisplay the menu bar
itself. That is exactly what I want! 

The next question is that are there any means that the table can be "unhide" which means it beomes available for changes? (So far, I
haven't use any User-Level Security features yet.)

I know this may not be a perfect answer because to make necessary database modification in the future, I have to modify the
unchanged version first and then copy it to create a cloned version which has Startups.... being modified.

Any comments are most welcome...

Bill. 

=========================================================================

> I have designed an application in Access 2000 which works as an electronic logbook. This application contains two features:
(> 1) to prevent the operator from changing a record which has been saved for over 3 minutes and there is a customized "Save"
button on the form. The VBA module to perform this function works perfectly.

> (2) to prevent the operator to go through backdoors to modify the table records. For example, I don't want the operator to
select "Window>Hide/Unhide..." option to open the table.
 >   (2.1) which implementation is easier and effective, hidding tables or  hidding the menulbar (or some of the options within
the menubar)?
 >   (2.2) do I still have to implement access user-level security feature after implementing the solution for (2.1) mentioned
above? 

> Thanks a million in advance,

> Bill.