I wrote the following query but it shows #deleted in place of all values. But I want it blank, only field names should be there.
delete * from table1
I wrote the following query but it shows #deleted in place of all values. But I want it blank, only field names should be there.
delete * from table1
Refresh the table or close and reopen and the #deleted should go away.
Wildcard not need in DELETE action: DELETE FROM table1
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks dude. yes it's fine after refresh.