>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]
- Re: BLACKSTONE: Software Development Times Art... Sean Corfield
- RE: BLACKSTONE: Software Development Times Article Matt Liotta
- RE: BLACKSTONE: Software Development Times Article Alexander Sherwood
- RE: BLACKSTONE: Software Development Times Article S . Isaac Dealey
- RE: BLACKSTONE: Software Development Times Article Tangorre, Michael
- RE: BLACKSTONE: Software Development Times Article Matt Liotta
- Access > SQL Question Donna French
- RE: BLACKSTONE: Software Development Times Article Dave Watts
- RE: BLACKSTONE: Software Development Times Article Matt Liotta
- RE: BLACKSTONE: Software Development Times Article Dave Watts
- Re: BLACKSTONE: Software Development Times Article dave
- Re: BLACKSTONE: Software Development Times Article S . Isaac Dealey
- RE: BLACKSTONE: Software Development Times Article Micha Schopman