Hi,
I'm doing an insert to a table using VBA. Sometimes the coding fails to insert, but it doesn't throw an error in the VBA. If I manually insert a record into that table, I can see that an auto-incremeted field has had a number consumed even though there's no associated record.
My coding looks like below:
1. Insert into Address table (Always succeeds)
2. Query newly added Addresses ID (Always succeeds)
3. Insert into People table (Sometimes fails)
*Note that above insert statements are simplified examples, but I have debugged the queries and verified there's no syntax issues, and the addressID returned from step #2 is accurate.
Bookmarks