Archiving Record (total of 3 questions)

  • Thread starter Thread starter JRoberts
  • Start date Start date
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.
 
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
 
Back
Top