MSDE + autonumbers

We have clients with Access databases. We are currently upgrading to MSDE and I have to come up with a data conversion program. Now, I can easily upsize it (but no data, it must be done at customer's site). However, how would I transfer the records with autonumber fields?? The records must be transferred by my conversion application.

Thanks,

in MSSQL the field is defined as Type = Integer, Allow Nulls = No, Identity = True.

You'll want to make sure that you SET IDENTITY INSERT ON first, before inserting the rows, that way the old Autonumber will come over proeprly.

Thanks,

Can I change it after that, so autonumber resumes?

Also, I only have MSDE installed and it doesn't come with Enterprise manager. How can I alter the Field's properties?

Thanks,

The identity in MSSQL is basically the same thing as Access's Autonumber...so you wouldn't want to turn it off.

Then how would I transfer the records preserving the autonumber values?

Try setting the field to an integer datatype...once the data has been transferred...then click the identity for that field so it will continue to increment the values.