Autonumber on an SQL server - Newbie to SQL server

[Gal Zilberman]

Hi
How Do I use the Autonumber field once I move the DB to an SQL server?

Gal

 

[Philipp Stiefel]

How Do I use the Autonumber field once I move the DB to an SQL server?

How do you use it now?

In general there is no big difference in the usage of
Automnumber/Identiy between Access and SQL-Server.
The main difference I'm aware of is, that in SQL-Server
an autonumber is only generated if you finally insert
a new record into a table while Access generates the
autonumber as soon as you start entering the data for
a new record.

Cheers
Phil

 

[Gal Zilberman]

That might be my problem
This table currently has more than 300,000 records, and when I try to add a
record, it doesn't calculate the Autonumber field, though on other smaller
tables it does.

A current workaround I'm using is by using an extra intermediating table
which generates the IDs.

It seems like the Idetity property is not working properly (it used to, BTW)

Gal

 

[Gal Zilberman]

Problem solved with the help of the SQL group.
When using SQL server as a backend, queries need to be tested using the SQL
Query Analizer, it shows the correct errors.

Gal