Solved New detail records being added despite disabled button in master form (2 Viewers)

[BlueSpruce]

It would be possible for a user to circumvent this by dropping the constraint of course, but this would need the user to be familiar with building DDL statements, which I'd imagine to be unlikely.

Other ways users can circumvent are:

1. Change customer's status to normal, add contract, change customer's status back to deceased.
2. Add contract record directly into the backend table.
3. Pre-date the contract by changing the system date.
4. etc. . .

There are many ways users can trick Access apps. There's no way to make them 100% secure.

 

[isladogs]

As a developer, you can prevent end users doing methods such as items 2 & 3 and make it more difficult to do workarounds such as 1.

 

[Ken Sheridan]

Other ways users can circumvent are:

1. Change customer's status to normal, add contract, change customer's status back to deceased.
2. Add contract record directly into the backend table.
3. Pre-date the contract by changing the system date.
4. etc. . .

There are many ways users can trick Access apps. There's no way to make them 100% secure.

1 and 2 would be prevented by applying the CHECK CONSTRAINT I described to the table.

 

[RonPaii]

Other ways users can circumvent are:

1. 
   
2. Pre-date the contract by changing the system date.

There are many ways users can trick Access apps. There's no way to make them 100% secure.

If your computers are joined to an Active Directory domain, they can be configured to get date / time from the server and disable the ability to change the date and time.