Solved Auto increment error

September 3, 2011 at 18:55:48
Specs: Windows XP
Iam trying to make a database using Visual Basic 2008. I created a DB in MS Access 2007 and connected to VB using data connection wizard. I add all the Fields. but when i run it and want to add a new employee the employed auto ID starts giving negative values..But in my DB it is auto number increment...what could be the problem

See More: Auto increment error

Report •

September 3, 2011 at 22:25:34
✔ Best Answer
Did you original have it configured for Random and then change it to Increment. If so then the database is incrementing from where the last Random number was which was probably negative. If you want it to increment from one then you are going have to delete the table and start again.

VB does not have unsigned integer it produces a number in the range -2,147,483,648 to 2,147,483,647. This is 32 bits with the left hand bit indicating positive or negative.


Report •

September 3, 2011 at 23:02:18
ooooooooooooohhhhhhhhhhhhhh...thank you Stuart...Yeah it was a simple mistake i made..Got it now....

may be i'll be needing your help in future. Hope you will help

Report •
Related Solutions

Ask Question