not sure if this should be considered security question or not

[sparks]

We have an access 2003 database on the main server that 8 people in
the group can log into. Ok I can have it log the name of the machine
that they log in from but not the user name logged into that machine.
There is no type of security on the database.

I need to filter the records based on the user name so they only see
their records. Should I put a password in the database and filter on
the password when they log into the database?

How should I set this up so they open the database and only see their
records?

thanks for any help ideas and/or links
hey its almost time for some labor day work..

have a great and long weekend I hope

[Larry Linson]

At the Access Web, FAQ for this newsgroup,
http://www.mvps.org/access/api/api0008.htm addresses "Get login name". Does
that help?

You can give the users access only to "RWOP -- Read with owner's
permissions" -- Queries that include a criteria based on the login name.
But, you will have to add a field to the pertinent tables to contain that
name, and, best not to show it, but use it only for the criteria.

Larry Linson
Microsoft Access MVP
"sparks" <js******@swbell.netwrote in message
news:uj********************************@4ax.com...

We have an access 2003 database on the main server that 8 people in
the group can log into. Ok I can have it log the name of the machine
that they log in from but not the user name logged into that machine.
There is no type of security on the database.

I need to filter the records based on the user name so they only see
their records. Should I put a password in the database and filter on
the password when they log into the database?

How should I set this up so they open the database and only see their
records?

thanks for any help ideas and/or links
hey its almost time for some labor day work..

have a great and long weekend I hope