entering data into MS Access database

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default entering data into MS Access database

    Hello,

    I'm creating an online survey using XHTML -- no PHP -- where the data will be
    entering into a MS Access database, and I am having trouble figuring out how to
    create a unique number/marker for a user if they are not logging in to the
    survey. I'm not interested in just having 1, 2, 3, 4, etc., but something that
    will identify a particular user.

    In the past I have had users log in, but with this survey I do not having the
    ability to use a log in feature. With the log in, a unique number was created
    an entered into the database, as a way to ensure that a user was not taking the
    survey more than once. I do not have the option of asking for their email
    address.

    Is there a way for a unique number to be generated per user so I can ensure
    the same person is not taking the survey twice? There will be 10,000+ people
    receiving the survey.

    I'm also interested in a way to ensure that the same data is not entered on
    multiple lines in the database.

    The survey will be one page only.

    Thanks!
    BW

    wwolff Guest

  2. Similar Questions and Discussions

    1. Entering listbox values into database
      Let's say I'm using SESSION variables to create a form-based wizard (it has 12 steps, and therefore 12 pages to the wizard). Some of the values the...
    2. PHP SMS access database and retreve data
      Hi everybody, I'm new at php I am strugling to get something working, my application sends a text message to a gateway and the gateway activates...
    3. Most efficient way of entering data into a SQL database
      Sorry this isn't necissarily ASP, but it is VBScript & ADO and I figure that you all would be the best to ask. I am using a VBScript that reads a...
    4. Posting XML data into My Access Database via ASP
      Hi, Im new to XML but trying to post the data in: http://guilds.camelotherald.com/guilds/Palomides/695.xml into my access database via ASP. ...
    5. Entering Data and then having another linked data show up.
      I am creating a form. What I need help doing is setting up the following. First, I have a list box with about 12- 15 options to choose. Each of...
  3. #2

    Default Re: entering data into MS Access database

    You can set a unique ID for every user, by using the CreateUUID() function.
    show us what you tried, so far, and we will try to improve it.
    SilverStrike Guest

  4. #3

    Default Re: entering data into MS Access database

    Hi

    Or else you can restrict to the user IP address.
    I think ben forta is doing the same thing in his site. once we post poll then we cant do post one more poll again.
    vkunirs Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139