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.
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)
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
