Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    Ashfaque is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    31

    Yes you are correct.

    My tblUser is on server and I will remove additional PK and set it on Username and will try n let you know accordingly.

  2. #32
    Ashfaque is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    31
    I removed PK from additional field in tblUser and set on USERNAME. But still same...Although msg is appearing that new user added but in reality no record saved. I debug and noted that the Expression variable has generated the encrypted password even but not saving at all.

  3. #33
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I know that new users are successfully added in my example app that you downloaded
    Unfortunately I have no means of knowing what the differences are in your modified version that is preventing it working for you.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #34
    Ashfaque is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    31
    I trying to find the error but till not traceable but still no success. Another thought, can I add new user using normal DAO recordset method? I mean if I do this then will there be any on encryption method?

    Please advise...

  5. #35
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by Ashfaque View Post
    I trying to find the error but till not traceable but still no success. Another thought, can I add new user using normal DAO recordset method? I mean if I do this then will there be any on encryption method?

    Please advise...
    If you add a user using a DAO recordset or, more simply, just by using an append query you will have issues if the default 'not set' password isn't encrypted.
    I think you are going to make this more difficult to manage ...and probably less secure ...if you try workrounds to fix your problem
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #36
    Ashfaque is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    31
    Thanks Isladogs,

    I know if both BE and FE are MS Access, it works great. Sir, just a question for my info...have a ever tried keeping this tblUsers on Server and added any new User from Access FE?

  7. #37
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Not with this particular app.
    However I have other Access FEs with user data including encrypted passwords that are stored on SQL Server backends
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hide a column in a report based on user rights
    By whisp0214 in forum Reports
    Replies: 6
    Last Post: 06-29-2017, 03:11 PM
  2. Log on form and user rights
    By HS_1 in forum Forms
    Replies: 18
    Last Post: 12-28-2016, 07:56 PM
  3. Problems with network rights and Access
    By Wayne311 in forum Security
    Replies: 3
    Last Post: 09-07-2011, 06:00 PM
  4. User always appear to connect with exclusive rights
    By kblinkhorn in forum Security
    Replies: 18
    Last Post: 09-02-2010, 01:07 PM
  5. Access Novice - Looking to learn from scratch.
    By Javaman in forum Database Design
    Replies: 1
    Last Post: 03-13-2010, 08:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums