Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Lock records after edit
0 views
Skip to first unread message
ebev
Jul 10, 2008, 7:44:02 PM7/10/08
to
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.
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.
PaulD
Jul 16, 2008, 2:22:46 PM7/16/08
to
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
certainly 'lock' them from a DAP. Just set the controls to disabled if they
try to look at an old day.
Paul D
"ebev" <eb...@discussions.microsoft.com> wrote in message
news:9BE5E713-C230-444D...@microsoft.com...
: Hello all, I am new to Access and I have a question. In the IT dept. where
0 new messages