not sure if this should be considered security question or not

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


.

Relevant Pages

  • Re: Viewing lists from a different server
    ... Instead of accessing the WSS database you ... when the site is on a different server. ... large list of items that sub-sites filter according to a custom ... action to display the filtered list on a site on this second server. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: New to selling on eBay
    ... believe everything is the same database. ... server if one is a mainframe IBM and the other a Sun server. ... I look for U.S. coins on these sites by entering a filter exclusion ... they let me filter Russian coins as to ...
    (rec.collecting.coins)
  • Re: Merge Replication Filter does not work at Subscriber
    ... Alternatively you could use partitioned tables (like federated database ... >I am setting up a SQL Server Database Filter based Merge Replication ... You can consider this as a Central Subscriber ...
    (microsoft.public.sqlserver.replication)
  • Re: OO vs. RDB challenge
    ... > Layer 1. ... If you filter your data after you retrieve it, ... possible to redesign the database schema to enable SQL to do its job. ... A good RDBMS could integrate an external authentication server. ...
    (comp.object)
  • Re: Access module does not continue past the Filter Method
    ... If you get this problem in any database at all, ... the subroutine went back to not working again. ... Public Sub Apply_Tech_Filter ... Debug.Print "Past the Filter" ...
    (microsoft.public.access.modulesdaovba)