Click here to Skip to main content
15,901,035 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
My problem is: I need to delete the data at runtime but when I delete the data it should not be removed completely from access database insteady in another table in the same database should be accessed. how can I do this in visual basic 2005( and if you can give sample code? Please help me! Thank you.

[edit]Subject, Tags, TxtSpeak, multiple exclamation marks, capitalization. - OriginalGriff[/edit]
Updated 4-Mar-11 20:57pm
thatraja 5-Mar-11 0:28am    
/* 4 everybody who want to give me ans */
Do you think is it a good title for your question? :(
Sandeep Mewara 5-Mar-11 0:29am    
I doubt if anyone would be interested in answering you until you show what effort have ou made. Further, your text speak would also turn away few people from answering.
OriginalGriff 5-Mar-11 2:58am    
That makes very little sense.
If you are deleting the data, why would you access it from a different table?

1 solution

Instead of deleting from one table and Inserting into another just use an extra column in table1 which gives the status of the record. Just change the status of the record to 'deleted/disabled' if you want to delete the record.
Share this answer
Costica U 5-Mar-11 18:24pm    
I agree.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900