log in and record information

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default log in and record information

    I want to be able to record the login on log in the time,date and IP of users
    within an access database is this possible? I can do this without problems
    when inserting, guess its a trick of combining login and update, not sure...has
    anyone any suggestions? Any help would be great thanks

    camenzka Guest

  2. Similar Questions and Discussions

    1. How can i retrieve record ONLY From 300 - 400 in amillion Record Table?
      HI all Thanks for your time.. I have a question here.. How can i retrieve record ONLY From XXX - XXX in a million Record Table? eg. I have a...
    2. Find record w/ conditions met in the same child record
      I'll use 2 files to demonstrate my question. The first file is Animal. It has 4 fields. Id (serial number) ZooId (number) Name (text) Food...
    3. using dropdown box to display db record & update record
      Hi Folks, I have a web database written in asp and using access97. I have many projects, but each project is being held responsible by a person....
    4. Stop adding record in subform after record count = 1
      Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the...
    5. Adding a new record when the record source is a query.
      Hello All, I have a form that runs a query. The reason it runs on a query is because prior to it opening I have a form from which you can pick...
  3. #2

    Default Re: log in and record information

    You can use Getdate() (SQL server) and Now() (Access) to set the Date and Time
    a Userlogs in.

    I have a tutorial which includes how to do this in ASP, you should be able to
    use simpe ASP code to grab the IP as well and add this to your log table.

    Tutorial = [url]http://www.dmxzone.com/ShowDetail.asp?NewsId=7645[/url]
    Part II = [url]http://www.dmxzone.com/ShowDetail.asp?NewsId=7674[/url]


    Originally posted by: camenzka
    I want to be able to record the login on log in the time,date and IP of users
    within an access database is this possible? I can do this without problems
    when inserting, guess its a trick of combining login and update, not sure...has
    anyone any suggestions? Any help would be great thanks



    CarlGrint 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