lock a record

[Nokia N93]

Hiii
i have created a payroll using access 2007. is there an option to lock only one specific record rather than the whole table.

For example, if John is no longer an emplyee i want to lock it and never be able to unlock it again.

if you can help me in the sample file

[ajetrumpet]

there's no such thing as "locking". you can do a number of things in the absense of that though. Like greyed out records, deleting records, throwing them to an 'archive' table, etc...

as a side note, no one that I know of deletes any information that has existed in the past. It's simply stored, in case it's needed ever again. You should always do this sort of thing too, because computers are powerful enough nowadays to store almost an infinite amount of data.

[orange]

you may want to move the record(s) involved to an Archive table.
If you allow user access only through Forms, then you can prevent people(general user) from seeing/touching the records. Some specific Admin functions may have to have access to the Archive table, but only through a form designed for that purpose.

For info on How Access does Locking here is an older link that has examples.
http://www.developer.com/tech/articl...ccess-2000.htm

[ajetrumpet]

you may want to move the record(s) involved to an Archive table.

hey orange,

no offense man, but reiterating what experienced professionals say on this site is really not cool. It doesn't contribute anything to the thread, and as a matter of fact, it makes you look pretty incompetent.

FYI!