Efficient VB.NET Table Archiving: Move Records Between Tables Monthly

  • Thread starter Thread starter Keyur
  • Start date Start date
  • Tags Tags
    Programming
AI Thread Summary
To move records from one table to another within the same Access database using VB.NET and the Jet OLEDB provider, an Append Query is required. This query allows for the addition of records from the source table to the destination table without deleting any existing records in the destination table. Once the Append Query is successfully created, it can be saved and executed on a recurring basis, such as at the beginning of each month, to facilitate the archiving process. The graphical user interface (GUI) of Access can assist in constructing this query.
Keyur
Messages
10
Reaction score
0
I have a table in access, it is linked to vb.net by jet oledb provider. I want to move all the records of this table to a new table which may already contain records. I have to move all the records of table 1 to table 2 at the 1st of every month. Table 2 may contain records, these should not be deleted.

Can anyone help with archiving of these records. Any help will be appreciated.
 
Technology news on Phys.org
To another table within the same access database?
 
DavidSnider said:
To another table within the same access database?

Yes, the same access database.
 
The GUI can help you with this. You need what's called an Append Query. If you write this successfully, you can save it and re-run it anytime you want to.
 
harborsparrow said:
The GUI can help you with this. You need what's called an Append Query. If you write this successfully, you can save it and re-run it anytime you want to.

Done with it.

THANK YOU ALL.
 
Thread 'Is this public key encryption?'

Thread 'Is this public key encryption?'

I've tried to intuit public key encryption but never quite managed. But this seems to wrap it up in a bow. This seems to be a very elegant way of transmitting a message publicly that only the sender and receiver can decipher. Is this how PKE works? No, it cant be. In the above case, the requester knows the target's "secret" key - because they have his ID, and therefore knows his birthdate.
View full post »

Thread 'Who is responsible for the software when AI takes over programming?'

I tried a web search "the loss of programming ", and found an article saying that all aspects of writing, developing, and testing software programs will one day all be handled through artificial intelligence. One must wonder then, who is responsible. WHO is responsible for any problems, bugs, deficiencies, or whatever malfunctions which the programs make their users endure? Things may work wrong however the "wrong" happens. AI needs to fix the problems for the users. Any way to...
View full post »

Similar threads

Comp Sci Optimizing Hash Table Storage for Efficient Record Retrieval
Replies
4
Views
2K
Moving records between tables in MS Access
Replies
1
Views
5K
Java Android Studio: Accessing SQLite Data In RecyclerView
Replies
1
Views
3K
I don't understand kind of program the instructions want
Replies
4
Views
3K
I need help, please, designing a pool sensor for breaking . . .
Replies
2
Views
134
Laptop screen flickering/moving up and down with pink tint
Replies
20
Views
6K
Modern Digital Audio: Understanding Dither and Oversampling in Hi-Res Age
Replies
17
Views
4K
I Where can I find publicly accessible data from observatories in Europe?
Replies
5
Views
2K
Does Water on the Table Improve Flip Cup Success?
Replies
2
Views
4K
Please Review Database Tables for Advanced Database Class
Replies
2
Views
4K

Hot Threads

Recent Insights

Back
Top