ASP database access!!

Results 1 to 2 of 2

Thread: ASP database access!!

  1. #1
    Join Date
    Dec 1969

    Default ASP database access!!

    Hi,<BR>I need help with accessing the last record in an access database table to retrieve the last number field(primary key) added. Then to increase this number field retrieved by 1 and then to insert it (old number +1) onto the end the same table as a new record. Because it is taking the first number in the table and adding the new record onto the top of the table.

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP database access!!

    Use:<BR><BR>sql="Select max(field) from DB"<BR><BR>to select the max number.

Posting Permissions

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