Sql = Access

Results 1 to 2 of 2

Thread: Sql = Access

  1. #1
    Join Date
    Dec 1969

    Default Sql = Access

    "Select @@Identity As &#039;Upload_id&#039; from upload"<BR><BR>This is in SQL, but I am now using an access db, does any body know how to convert this statement to work in accsss or point me in the right direction. Thank You! :)<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Sql = Access

    As long as you are using the latest version of MDAC:<BR><BR>Select @@Identity As Upload_id from upload<BR><BR>Craig.

Posting Permissions

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