Securing a form

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

Guest

Hi

I have a table updated by a form, one of the fields records the date
modified this is automatically generated by the VB code below in the Before
Update field in the Properties dialog box as below.

This works fine as it came from a MVP form this newsgroup.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Date_Modified = Now()
End Sub

It was noted in the newsgroup that this would only work if the updates were
made in the form. Is there anyway to lock the database such that the user is
forced to update in the form and not in the table?

Thanks in advance

DomNHS
 
It depends on the technical savvy of your users. If they are unaware of the
Shift key bypass you can simply prevent the database window from showing. Go
to Tools > Startup and uncheck Display Database Window and Use Special Keys.
If they are aware of the bypass, then you may want to disable it. The code
for doing that can be found at:

http://www.mvps.org/access/general/gen0040.htm
 
Back
Top