Sequence break in key number field

[orsonros]

Hi!

1. If accidently a record or two in a sequence are deleted, how will you know that this has happened! What type of validation can be enforcedto prevent this?

2. How do you make your Tables, Quries, Forms, Reports, Macro tamper proof?

Please help!

Orsonros

 

[Len Boorman]

Called Security

Len

 

[Pat Hartman]

You cannot rely on autonumbers to maintain an uninterupted sequence so if you need on, you'll need to generate your own sequence number fields.

If your business rules specify that records may not be deleted, you'll need to implement security to prevent deletes. If you lock users out of the database window and only allow access via forms, you can set the forms to not allow deletes but that is certainly much less secure than implementing real user level security.