First, let me apologize in advance for posting a question which probably doesn't have enough information, but I'm hoping somebody can just help point me in the right direction.
In VBA in Access, I dynamically build an "INSERT INTO ..." statement. My program runs through hundreds of records, inserting them happily, and then throws up a Run-time error 3155 (ODBC Timeout).
I'm actually a newbie in terms of knowing how to debug my code. I've wracked my brain. I've displayed a msgbox that shows the "INSERT INTO ..." statement and I can't see any obvious difference between the ones that work and the ones that don't.
You folks are generally so very, very helpful that I'm hoping maybe you could point me in the right direction to try to solve this (like pointers in using the built-in debugging tools).
Thanks,
Bev
In VBA in Access, I dynamically build an "INSERT INTO ..." statement. My program runs through hundreds of records, inserting them happily, and then throws up a Run-time error 3155 (ODBC Timeout).
I'm actually a newbie in terms of knowing how to debug my code. I've wracked my brain. I've displayed a msgbox that shows the "INSERT INTO ..." statement and I can't see any obvious difference between the ones that work and the ones that don't.
You folks are generally so very, very helpful that I'm hoping maybe you could point me in the right direction to try to solve this (like pointers in using the built-in debugging tools).
Thanks,
Bev