I'm not sure how to lock specific records inside of access, but you could
certainly 'lock' them from a DAP. Just set the controls to disabled if they
try to look at an old day.
Paul D
"ebev" <e
...@discussions.microsoft.com> wrote in message
news:9BE5E713-C230-444D-B0F9-FF88DD131729@microsoft.com...
: Hello all, I am new to Access and I have a question. In the IT dept. where
I
: work we have a daily checklist that we use. It was made in Access 2003 and
a
: data access page was set up. My IT manager wants
: the database set up so when we are done for the day and create a new day
: the old day will lock and not be editable. Is it possible to do this
: and if so how is it done? Alternately we can use a button or checkbox to
lock
: the records if it is any easer. Thanks in advance for any help you can
give.