We migrated a database using autonumber fields from Access to SQL-Server.
After a while we detected the IDENTIFIER type.
Now we have the following problem.
When adding a new record in Access, the new number is provided as soon as the first field is entered.
In SQL the record behaves different. The autonumber field turns blank.
Our Frontend application has now problems to save the record.
Any ideas to overcome this.
Thanks.
Christof.
After a while we detected the IDENTIFIER type.
Now we have the following problem.
When adding a new record in Access, the new number is provided as soon as the first field is entered.
In SQL the record behaves different. The autonumber field turns blank.
Our Frontend application has now problems to save the record.
Any ideas to overcome this.
Thanks.
Christof.