Hidden value / table?

Problem:

I need to connect a VB application (MsAccess based) to a 3rd party oracle light database.
For the most of it this works just fine, I only have one problem:

The 3rd party application generates key values for a table when creating a new record. This is not an autonumber field. When I add records from my own application and go back to the 3rd party application, this one generates key values as if no records had been added in the meantime. So obviously it stores the last value it has given out and uses this value to genarate the new number.

Using a texteditor and comparing a database before and after an addnew, I found the value in the database. When I change it, this new value is used to generate the next key.

Obviously changing this value with a texteditor every time I want to use the 3rd party program is not a good option. So I wonder how this value could be stored and how I can access it using ADO.

Is there a way to store variables other then in tables? or do hidden tables exist and if so: how do I unhide them?

Please help,

Paul_at_vulcano.demon.nl Received on Mon Jul 23 2001 - 21:02:40 CEST