Archiving Record (total of 3 questions)

J

JRoberts

How would I be able to archive a record prior to deleting
it. And how would I be able to place someones entire
Social Security Number into our database and hide all but
the last four numbers. And is there a way to place a
password on the system so unauthorized people cannot enter
the database. Thanks in advance.
 
P

Pieter Wijnen

1)
Place code on delete trigger of the form (or upgrade data to mssql or
oracle & create data triggers)
2)
pretty hefty coding required for that
3)
you can put a db password on the database - or better secure it
(tools/security/security wizard + help + mdn.microsoft.com or yours truly)

Pieter
 
Top