[MS_AccessPros] Re: ''' user level security

 

Hi Youssef,

You will need to use add the UserName as a new field
in the Table that is the source for the records.

You can/should use the UserName automatically by using
=Application.CurrentUser
as the DefaulValue in the new field.

You can then allow only the user that created the
record to make changes to it by comparing the saved
value with the CurrentUser value.

Something else you will need to do is to allocate all
existing records to each user. To do that may be the
hardest part of the job.

Hope that helps.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "Youssef" <youssef2309@...> wrote:
>
> I have a multiuser database
>
> how to control the user when open a form to "view, edit or delete" ONLY the
> records that he previously recorded
>
>
> thanks in advance
>

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 2
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___