If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto-Increment Issue (couldn't find this one)
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 |
#2
|
|||
|
|||
Auto-Increment Issue (couldn't find this one)
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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "nickf" wrote: 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 |
#3
|
|||
|
|||
Auto-Increment Issue (couldn't find this one)
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 "nickf" wrote in message ... 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 |
#4
|
|||
|
|||
Auto-Increment Issue (couldn't find this one)
"nickf" wrote in message ... 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 |
#5
|
|||
|
|||
Auto-Increment Issue (couldn't find this one)
kkk;;;vvv
"nickf" a écrit dans le message de groupe de discussion : ... 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 |
Thread Tools | |
Display Modes | |
|
|