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