Hi,

A user logs on to the application. When the password is checked in the table
Users I use the field user_id from that table to determine his rights in my
application. So I display only those records of a table WHERE RelationOf
LIKE user_id.

Can I use this method safely? What if 3 or 4 users are using the application
simultanuesly? Can Access 2003 keep them apart or is it possible that
user_id 3 gets the data of say user_id 2 ?

I tested it and didn't get errors so far which doesn't mean it's OK though.

Does anyone has any experiance or knoledge about this topic?

Sorry for my english.

Thanks,


Susan

Yes, Access can differentiate them. You should really look into user-level
security (ULS). look at the help file or goolgle the terms as there is a
lots of information on this subject. With it you can check the user easily
by using the currentuser() fucntion.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"susan" wrote:

> Hi,
>
> A user logs on to the application. When the password is checked in the table
> Users I use the field user_id from that table to determine his rights in my
> application. So I display only those records of a table WHERE RelationOf
> LIKE user_id.
>
> Can I use this method safely? What if 3 or 4 users are using the application
> simultanuesly? Can Access 2003 keep them apart or is it possible that
> user_id 3 gets the data of say user_id 2 ?
>
> I tested it and didn't get errors so far which doesn't mean it's OK though.
>
> Does anyone has any experiance or knoledge about this topic?
>
> Sorry for my english.
>
> Thanks,
>
>
> Susan
>
>
>

The main point here is that for it to keep the users separated, you will
need to be sure you are using a split database and each user has their own
copy of the front end on their computer.

"susan" <(E-Mail Removed)> wrote in message
news:4d5d4$490579b7$524b0a9c$(E-Mail Removed)...
> Hi,
>
> A user logs on to the application. When the password is checked in the
> table Users I use the field user_id from that table to determine his
> rights in my application. So I display only those records of a table WHERE
> RelationOf LIKE user_id.
>
> Can I use this method safely? What if 3 or 4 users are using the
> application simultanuesly? Can Access 2003 keep them apart or is it
> possible that user_id 3 gets the data of say user_id 2 ?
>
> I tested it and didn't get errors so far which doesn't mean it's OK
> though.
>
> Does anyone has any experiance or knoledge about this topic?
>
> Sorry for my english.
>
> Thanks,
>
>
> Susan
>