I am accessing an Access 2000 database and was wondering how I would go about utilizing the Auto-incremment field. When I insert a record, the required field checks are made, however, Delphi allows me to leave the Auto-Increment field (which happens to be the primary key) blank and does not assign a new one number. If I can't have BDE/Access generate a new ID each time a record is inserted, I'll have to waste time using Visual Basic to build this program.
One note for any perspective answer-er. This MDB file will be used in a multi-user environment and already has 65,000 records - so answers suggesting background queries or first/end loops would be extremely slow.
Any help or comments are appreciated as I really need this resolved as soon as possible.
Thanks in Advance.