Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Adelaide
    Posts
    1

    Unanswered: Access User views

    Is it possible when creating seperate user accounts, to allow each user to only view the records that they have created.

  2. #2
    Join Date
    Feb 2002
    Posts
    403

  3. #3
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    You can't make it rock solid safe with MS Access only. You could insert an additional field in your table(s), lets assume we'll call it UserCreated, storing the user creating the record. I found no way to set the default value of a field in a table directly to CurrentUser() thus you'll have to do it in a control on the form(s). In all your queries you'd place a WHERE UserCreated = CurrentUser(). With a properly secured front end it should be sufficiently secure for most applications. Easier and more secure would it work with a "real" DBMS as back end though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •