Inserts followed by selects

Results 1 to 2 of 2

Thread: Inserts followed by selects

  1. #1
    Nate Baxley Guest

    Default Inserts followed by selects

    I have an Access database I&#039m updating with an AutoNumber field. I insert an entery into the table and then want to know what the AutoNumber is. So I run a select on the table and get the highest number with the values that I inserted. But I get nothing back. Any ideas on why this wouldn&#039t work? Is there a commit I have to do or something similar? Or can I find the autoNumber another way. I&#039d rather not add one to the maximum number before the insert as there may be several that happen in close proximity and I may step on toes. Any help would be appreciated.<BR><BR>Nate Baxley

  2. #2
    Markkk Guest

    Default RE: Inserts followed by selects


Posting Permissions

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