Is there anyway for Access to retrieve values from an Oracle Sequencer?  I 
need to able to insert the values from an Oracle sequencer into an Access 
table.  No other numbering sequence can be substituted.

you could write a stored procedure that got the next number and returned it
to your app.

-----Original Message-----
From: Gregory Montague [mailto:gregory_montague@g...]
Sent: Thursday, September 26, 2002 7:56 AM
To: Access
Subject: [access] Access and Oracle Sequencer


Is there anyway for Access to retrieve values from an Oracle Sequencer?  I 
need to able to insert the values from an Oracle sequencer into an Access 
table.  No other numbering sequence can be substituted.