Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"#Deleted" field when I delete records in the Table?

Status
Not open for further replies.

OverDrive

IS-IT--Management
Dec 11, 2000
268
US
Why am I getting a "#Deleted" in every field for every record once I delete them from the Table? Is there any way to change this or do it better.

Scenario:
A user wants to back up his/her records in the database. He/she clicks on the button "View Full Table" to view the table, he/she highlights all the records and copies them to an excel document (or other media type), then deletes all the records in the table once he/she has backed them up.

The only problem is that if he/she had 100 records in the field, he/she now has 100 records full of "#Deleted" fields that they need to delete one by one (in form view) even though they do not display that way in the Table (since it is blank now)?

Anyone have an idea on how to fix, modify or make this a better way for them to back up their records?

Gord? (hehe)
Chance~
 
Well, I noticed that if I get out of the database, and then get back into it, they have all dissapeared. So all in all this is not really as big of a problem as I thought it was. But if anyone knows a better way of backing up a database PLEASE let me know . . .

Thanks
Chance~
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top