Results 1 to 2 of 2

Decrypting data in SQL Server backend table from Access front end

  1. #1
    Analyst226 is offline Novice
    Windows XP Access 2016
    Join Date
    Jul 2017
    Posts
    2

    Decrypting data in SQL Server backend table from Access front end


    I recently just migrated my back-end end tables from Access to SQL serves but still using the Access front-end. In the process of doing so, I decided to encrypt the Password column (which stores user passwords when accessing the database) to one of my back-end tables in SQL. After linking that back-end table to my Access front end, users are now unable to access the database due to Access not reading the Password encrypted data.

    Is there a way to resolve this issue?

  2. #2
    ssanfu is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    7,005
    Have you tried using SSMS and deleting the Password encrypted field in the table? Then you could add the field/data (un-encrypted?) again.

    Maybe you could use a SP to compare the UID/PW in the BE instead of the FE - then might not have to encrypt the PW.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-26-2016, 02:18 PM
  2. Front-end Access Backend Teradata
    By tmcrouse in forum Forms
    Replies: 2
    Last Post: 08-05-2014, 02:45 PM
  3. Replies: 2
    Last Post: 06-25-2014, 05:57 AM
  4. Replies: 5
    Last Post: 11-13-2012, 11:16 AM
  5. MS Access Front End MS Excel Backend
    By spideynok in forum Import/Export Data
    Replies: 2
    Last Post: 03-18-2012, 08:15 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
  •  
Tech Forums: Microsoft Office Forums