>I have a table that I transferred from Access to SQL and had a field
>setup as auto number. Now I am getting an error message when I try to
>submit new info to the table in SQL.
>


Yes You will need to go into SQL enterprise manager and make the col that was auto number in access to Identity  you set the Identity seed (number to start) and Identity increment to how you want it to increment.

Mark Holm
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to