MSDE + autonumbers

[vbgladiator]

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,

[techgnome]

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.

[vbgladiator]

Thanks,

Can I change it after that, so autonumber resumes?

[vbgladiator]

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

Thanks,

[Memnoch1207]

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

[vbgladiator]

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

[Memnoch1207]

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.