I have a SQL 2000 database with an autonumber as the key field (intNewIntkey), I restored the database to a test system and ran this code: -
Do Until rst.BOF Or rst.EOF = True
![ContractNumber] = rst!ContractNumber
![Description] = rst!Description
.Bookmark = .LastModified
intNewIntkey = ![InternalKeyNumber]
I ran this on the test and imported 300 items no problem, on the live it fails as the InternalKeyNumber is null (error 3022), can anyone help?