I have an access table with an autovalue as primary key.
The problem is now when i create a new dataset with the command:
Dim RS As Recordset
i need to have the generated autokey value from the underlaying db table. Because other tables have references to the primary key. At this moment the autokey value is 0.
When i make a:
the RS will be 'rebuild' and i don't find the dataset that i have added before. (Beside the autokey value is now set to a correct value)
At the moment a haven't found a properly method.