Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Using Sequence with Access


    I have an Oracle Database running in the backend and I am using Access for the frontend forums. I have some sequences on a few tables, I am wondering how I can use this in access. I want to lock the field and have it auto populated with the value of the sequence. Can you help me? Help much appreciated!

    Tyler Cranston

  2. #2
    Join Date
    Nov 2002
    select <sq_your_sequence>.nextval from dual;
    then insert the retrieved value into access and populate

Posting Permissions

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