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

  • Thread starter Thread starter nickf
  • Start date Start date
N

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
 
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.
 
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
 
nickf said:
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
Click to expand...
 
Back
Top