SpeedThink
Registered User.
- Local time
- Today, 13:08
- Joined
- Mar 10, 2005
- Messages
- 15
Each day at 7:00 a.m., a macro within Access appends records from Oracle 9 database into local Access table.
Specifically, I have a passthru query that is converted to an append query and within a macro.
Currently, trying to capture possible errors encountered when appending the records.
Upon arriving in office at 8:00, I would like to access a table that reveals any errors encountered during the import and then running the macro manually.
Is this possible?
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Specifically, I have a passthru query that is converted to an append query and within a macro.
Currently, trying to capture possible errors encountered when appending the records.
Upon arriving in office at 8:00, I would like to access a table that reveals any errors encountered during the import and then running the macro manually.
Is this possible?
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
