limiting access on a record-by-record basis

[alain delcourt]

I am developping an application to be used on the same PC by several users.

I want to limit the access on a record-by-record basis, so people would only have access (for editing) to the records they created.

My first idea was to proceed as follows:

1 Define a text field named Record_created_by.

2 Set the auto-entry options for that field to auto-enter the name of the record's creator (choose File menu > Define Fields, select the Record_created_by field, then select Options > Auto-Enter > the Creator Name).

3 Define a password with the Browse records access privilege limited to records that match the calculation:

Record_created_by = Status(CurrentUserName)

Now my problem: The variable "CurrentUserName" is set by default to my name (Alain). It can be changed manually in edit/preferences/application, but if another user access the database with his password, he is not asked for a login, then he will log under my name and see the records I created!

Can anyone help me?

Alain, Sao Paulo, Brazil

[BobWeaver]

Give each user a different password, and assign each password a different group. Then use the status function Status (CurrentGroups) instead of the user name in your formula.

[alain delcourt]

Thanks for your help

As you can see I am a newbie, so excuse me if my question seems fool, but I don't now how to assign each password a different group in FM 6.1. It seems you can assign each file some passwords and some groups, but where can I administrate the relation between passwords and groups?

Alain

[BobWeaver]

It's not very intuitive, and at the moment I can't remember without setting the whole thing up. The manual explains passwords and groups reasonably well though.