Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jul 2002
    Location
    Deer Park, TX
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Preventing duplicate entries into an access db

    What is the best method for handling the prevention of users entering duplicate information into an access database. For instance I am attempting to prevent someone from duplicating an email address when they register for membership.

  • #2
    New Coder
    Join Date
    Jun 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts
    My quess would check the database and match it with the submitted email address.

  • #3
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can set that up at the database level, by setting a single-field primary key. This prohibits duplicate values in that field.

    You have to provide code, though, to trap and handle the error at run time, in case an attempt to insert a duplicate entry is detected.


  •  

    Posting Permissions

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