Autonumber on an SQL server - Newbie to SQL server

  • Thread starter Thread starter Gal Zilberman
  • Start date Start date
Gal Zilberman said:
How Do I use the Autonumber field once I move the DB to an SQL server?
Click to expand...

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
 
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
 
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
 
Back
Top