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
delete query produce #deleted in all deleted values
Advanced Beginner
Windows XP 
Access 2007
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
VIP
Windows XP Access 2010 32bit
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.
Advanced Beginner
Windows XP Access 2007
Thanks dude. yes it's fine after refresh.
Cannot Delete a Record "# Deleted" in ALl Fields
Posting Permissions
Reply With Quote