Protecting records

  • Thread starter Thread starter pack
  • Start date Start date
P

pack

I have a table that is updated monthly, in a multi user
environment. Oftem times someone inadvertently changes
the prior month's data while entering/editing the current
months data.

Is there a way that I can lock/protect prior months
records, so that they can not be edited inadvertantly?

Thanks
 
You could base your form on a query that shows ONLY the current month's
records:

SELECT * FROM YourTAble WHERE YourDate>=#" & DatePart("mm", Now()) & "-01-"
& DatePart("yyyy",Now()) & "#"

Note the above is aircode, so you may have some typos ...

Set your form's Recordsource to something similar, and your users will only
see the records for the current month and year.

Of course, if your users are entering data directly in the tables, then all
bets are off and you're just begging for trouble <grin>
 
Back
Top