Dear All

I have read about locking a record but I really do not understand the way how people make it. For example, I have a database named A ...in A ...I have a several records ...how can lock record number one or record number 3 so that people can only see but not edit it and unlock it to edit?

Where can I find an example about locking record?

Thanks All

In the Access Privileges --> Passwords dialog you can set limited access by record defined by calculations for Browse, Edit and Delete. Just setup three field in Define Fields (uh, how about "Browse", "Edit", and "Delete"). If each of these fields is "true" the corresponding ability is enabled (for the passwords defined to use this feature, including "no password"). Then it is just a matter of deciding how you will control the values of these fields. By setting them directly? By making the fields calculation field?

-bd

I have done what you said but I got the message error:

"In this set of password, no user can access the entire file.

At least one user must be able to access the entire file. "

I click "no passord" or make a password ...it gives me the same error. I work the file on my destop.

Why on the host, the file does not give me the access to "Access Privileges-> password?

Do you have any ideas about this?

Thanks a lot

I am having the same problem. I am running a script that sets the field 'ModifyAllow" to either 1 or 0 valeu then using the limited Edit function simply using the field "ModifyAllow" for the 1 = true or 0= false. It would seem though that once the record is locked for editing that I can no longer set the field to 1 eg allow editing.

I am going to try to create a related database and set the field ModifyAllow in the related DB.

I'll let you know how I go.

Using the Access Privledges in this manner will cause the exact problems descirbed above.

In this situation, I always opt to use scripting to control the access. Filemaker's internal security is much more secure, but also less robust and flexible.

Have an editing layout, which allow entry into the fields. Also create a browsing layout, which does not allow access to any of the field. Provide a button on the screen that allows the user to enter edit mode. Once a user click the button, the script checks a lock flag field, and if it is set to 1, takes them to the editing layout and sets the flag to 0. Another button on the editing screen can "save" the record, unlock the flag and return the user to the browsing layout.

Anh_Tran said:

.....I got the message error:

"In this set of password, no user can access the entire file.

At least one user must be able to access the entire file. "Do you have any ideas about this?

Make at least one password with the "User can access the whole file" checkbox on.

Ernst

Thanks for your advice captKurt. My DB consists of about 8 layouts on which particular some fields occur repeatedley and only fields need to be 'locked'. I have opted for the following solution.

Set the Field format option to 'do not allow entry to field'

I have a ModifyAllow field flagged with either 0 or 1

A seperate script for each field

if(ModifyAllow=1)

GotoField(Fieldname)

Else

Beep

EndIf

I set each field through Specify button - perform script (script name)

I also have a small padlock Icon that sets the ModifyAllow field to 0 or 1.

Hope this helps