G
Gal Zilberman
Hi
How Do I use the Autonumber field once I move the DB to an SQL server?
Gal
How Do I use the Autonumber field once I move the DB to an SQL server?
Gal
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Philipp Stiefel
Gal Zilberman said: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
G
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
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
G
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
When using SQL server as a backend, queries need to be tested using the SQL
Query Analizer, it shows the correct errors.
Gal