Hi Clive,
I'm already added the username in all tables
as "My database used for BMW Egypt ordring materials"
So, my problem is how to autmatically filter the recrods related to a certian user with "ON OPEN" form action as this action should be general for all forms.
Thanks in advance
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi Youssef,
>
> You will need to store the UserName in all records
> that have been recorded by each particular user.
>
> You can then either filter the records according to which
> user is using the DataBase, or show all the records but
> allow the user from changing only the records that
> have been entered by him.
>
> 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 (4) |
Tidak ada komentar:
Posting Komentar