data entry form programming

I have a database with a table of users and data that is associated
with each user. How can I make it so that when a user logs in, they
can see only their table of data? Also, would it be possible, or
easier, for the windows log-in to be in control of the database log-in
and corresponding data access?

Thank you,
Kostya

Sounds like you need SQL server. I don't think you'll find a really secure
Access ssytem. If you want a pseudo-security system, you could implement a
log-in/ password scheme on a splash form and have a different form designed
for each group of people to access, ie, one form with SSANs, one without...
but this could be bypassed by someone with Access smarts.

" wrote:

I have a database with a table of users and data that is associated
with each user. How can I make it so that when a user logs in, they
can see only their table of data? Also, would it be possible, or
easier, for the windows log-in to be in control of the database log-in
and corresponding data access?

Thank you,
Kostya