>>Actually, I believe a few bytes unused in the .dbf header was stolen to store the next id value. If you already have values, when you change the type to auto-increment you can specify the 'next id' so it wont conflict with your existing numbers.
>>
>>BOb
>
>Were I Irish I would have known that you were pulling my leg - Lepracauns, an Irish friend tells me, would only promised the cheese to the mouse and not actually given the mouse any.
>
>Thanks for the info, Bob.
>
Hi Gil,

In addition to what Bos said, making field of auto-increment type doesn't affect existing data. For example, if you add auto-increment field to your table it will not be back populated.