Re: Allowing users to view only their own data

Ed wrote:

I am trying to create a access database that will allow a "user" to
login, and only view/change only the material they have entered. Also
allowing a administrator to view all the data, and create reports from
them. Any good ideas? I kinda of had an idea of creating a seperate
table with usernames and passwords then writing a visual basic and sql
combination to allow them only to view and edit their own data.

I'd look at the SeqFaq for access. Using/modifying code found there you should be able to do what you'd like.
.

Relevant Pages

  • Re: >> Converting a work computer to a home computer?
    ... When I login to windows, ... Before anything else, you need to be able to log in as an administrator, ... member of a domain to a workgroup. ... network settings that point to invalid servers ...
    (microsoft.public.windowsxp.general)
  • Re: "user does not have access privileges"
    ... I do not know what is up with the briefcase behavior, ... but I notice you have Pro, and Pro does allow login ... with Administrator without halting use of the Welcome ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Domain users unable to print to parralel printer
    ... Additionally I have disabled the logon scripts that maps drive automatically upon domain users login but did not help to fix the problem. ... I don't understand why a new created domain account with the same privileges as the existing users can print. ... Did you configure the printer as "Default printer" after installing with the administrator account? ... workstations and we encounter a very strange problem which we can't ...
    (microsoft.public.windows.server.networking)
  • Re: Creating User Logins - Administrator disappeared...
    ... > I have answered a few questions for others in the Excel forum and I know how ... Once you create additional user accounts, the built-in Administrator account becomes hidden. ... >>> "Administrator" disappeared as a choice of users in the windows login page. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Workgroup to Domain
    ... have user run file and settings transfer wizard to save their settings. ... Log in as local administrator ... Login as domain user to create profile ...
    (microsoft.public.win2000.networking)