Passwording the Delete Record Function

[MagiChef]

Does anyone have an idea as to how I can force a passwordfor deleting records??? [email protected]

[danjacoby]

quote:

---

Originally posted by MagiChef:

Does anyone have an idea as to how I can force a passwordfor deleting records???

---

Quite possibly -- it depends on what you mean.

What do you mean?

[Vaughan]

If you mean let people access the database freely UNTIL they go to delete a record, when they get asked for a password (or a different password) no, not using FMP's built in access privileges.

You could create an interface that could do something like this, but then it's not *really* secure.

[danjacoby]

First, you have to limit their access thru sign-in passwords, so that they can only delete the record via a button.

Then script the button to go to a layout containing a password field (I'd use a global field) and instructions to enter the password in order to delete the record, and pause. When they continue, the script compares the entered password with the correct password and either deletes the record or doesn't. Finally, the script clears the global password field and returns to the original layout.

HTH,

Dan

[Steven H. Blackwell]

quote:

---

Originally posted by MagiChef:

Does anyone have an idea as to how I can force a passwordfor deleting records???

[email protected]

---

It depends on the Operating System you are using. You do this one way for Mac OS, another way for Windows OS. Which are you using? It also makes a difference what version of FMP you are using.

Old Advance Man