I just tried what I said above and no luck... (i should really try this stuff out before i open my big mouth). But if you want your autonumber field to start at 1 then you could just delete your ...

Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...

I am saving a record to a database on SQL server 2k that has a field 'id' -- it is an autonumbered/identity field and thus auto-increments as necessary when saving records.<BR><BR><BR>At any rate, ...