I'm experiencing an issue with deleting records on the Linked Table (Oracle) from MS Access 2007. I'm executing the following in VBA:
CurrentDb.execute Delete TableName.* FROM TableName
I expect this would delete all records, however it's just deleting 1 record.
Any help would be appreciated.