Auto-Increment Issue (couldn't find this one)

[nickf]

Windows XP Service Pack 3
Access 2007 (from Office 2007)
Visual Basic 6.0

I have a table with an auto-increment column. This time of year, there is a
lot of deleting and inserting going on in that table. Inserts are done
through a Visual Basic program that does not touch the auto-increment field.
Now and then, more so this time of year, I get a duplicate in the field and
of course if fails. I found that, to fix it, I have too compact and repair
the data base. Needless to say, that gets tiresome doing it multiple times
in one day.

Any solutions?

thanx,
nick

 

[Jerry Whittle]

Is it an mdb or accdb file?

"Auto-Increment". Do you mean an autonumber data type of some other method
of incrementing that field?

What service pack are you on? Office Button, Access Options, Resources,
about Microsoft Office Access.

Are you sure that the VB program doesn't mess with that field.

 

[Gina Whipp]

nickf,

In addition to what Jerry said... have a look at...

http://allenbrowne.com/ser-40.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Windows XP Service Pack 3
Access 2007 (from Office 2007)
Visual Basic 6.0

I have a table with an auto-increment column. This time of year, there is a
lot of deleting and inserting going on in that table. Inserts are done
through a Visual Basic program that does not touch the auto-increment field.
Now and then, more so this time of year, I get a duplicate in the field and
of course if fails. I found that, to fix it, I have too compact and repair
the data base. Needless to say, that gets tiresome doing it multiple times
in one day.

Any solutions?

thanx,
nick

 

[De Jager]

Windows XP Service Pack 3
Access 2007 (from Office 2007)
Visual Basic 6.0

I have a table with an auto-increment column. This time of year, there is
a
lot of deleting and inserting going on in that table. Inserts are done
through a Visual Basic program that does not touch the auto-increment
field.
Now and then, more so this time of year, I get a duplicate in the field
and
of course if fails. I found that, to fix it, I have too compact and
repair
the data base. Needless to say, that gets tiresome doing it multiple
times
in one day.

Any solutions?

thanx,
nick

 

[joelgeraldine]

kkk;;;vvv