Avatar of Kinlene
Flag for United States of America asked on

MS Access Database- Survey Issue

To whom it may concern:

I am working on a MS ACCESS database in which users take a simple "Yes" and "No" survey (See Attachment).  The survey use's Social Security Numbers as the primary key.  I realize this isn't normal, however, my military "customer" requires the SSN for this application, so I have no way around it.  I must use the full SSN.  The database application functions perfectly except for when a user has a "Zero" in the beginning of their SSN.  I have set the data type to text and the input mask is set to be a SSN.  I have provided the original database (See Attachment) where the SSN was originally a field named "PerticipantID".  This eventually became the SSN in the final application.  I migrated this survey application into my finished application with little trouble.  It wasn't until users started using the new survey, that I identified the issue, so I checked the provided original (See Attachment) and that too is having the same issue.  I had originally thought I missed something, but when I saw the original survey had the same issue, I realized is must be something else.  Note:  Anyone else with any other SSN or Participant ID other than one that starts with a "Zero" works just the way I wanted it to.  Any assistance you could provide after review of this survey will be greatly appriciated.

Edward J Kinlen
Microsoft AccessMicrosoft Applications

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

It worked thanks!

Glad that helped out :)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Are you SURE you really want to store a full SSN in an Access database? Are you SURE you want that responsibility ... if someone walks off with the db? Access dbs have essentially NO security.

Just sayin' ...
Your help has saved me hundreds of hours of internet surfing.