Autonumber: Different behaviour of Access and SQL Server

Dillen

Registered User.
Local time
Today, 09:16
Joined
Jan 13, 2005
Messages
14
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.
 
It shouldn't have a problem. You just won't see the new autonumber value until after you save the record.

What exactly is the problem you are experiencing?
 
OK - works now - Problem was in a complete other area.
Thx.
 

Users who are viewing this thread

Back
Top Bottom