Extra_Cover
Registered User.
- Local time
- Today, 12:12
- Joined
- Oct 21, 2008
- Messages
- 71
Has anyone else come across this problem in MS Access 2000?
I have an application that updates from an ODBC source overnight using a macro that is run from Scheduled Tasks. There are several tables that are first deleted using DeleteObject and then re-impoted using TransferDatabase. However the DeleteObject for the last table does not delete the tables. The TransferDatabase action then reimports the table but the suffix 1 is added. ??
I have an application that updates from an ODBC source overnight using a macro that is run from Scheduled Tasks. There are several tables that are first deleted using DeleteObject and then re-impoted using TransferDatabase. However the DeleteObject for the last table does not delete the tables. The TransferDatabase action then reimports the table but the suffix 1 is added. ??