Moving MS Access records?

cordie · Joined: 24 Jan 2005 Posts: 7

Hello. I am practicing inside this program for some weeks already, and so far I didn’t reached near any difficulties. And so far means that I actually am in encounter right now. I am afraid to transfer some records from one to another particular table. How do I do that? It is quite certain that I can manage this by myself, but I want to make sure, just for any case. Thanks in advance.

forrester · Joined: 28 Oct 2007 Posts: 4

Hello. You need to create one single move. That move will consist of two action queries. Action and Delete Query, where transaction blocks the Delete if the Append didn’t succeeded in some case. You don’t need to make archives, only steps like these are needed: Execute the Append Query when the transaction is started. Execute the delete query too. To commit the changes you will need to get user confirmation. Just roll back the transaction, if anything goes wrong.

H-Desk.com - PC Security matters - Protect your PC privacy

Moving MS Access records?

LIFEFORM SOCIAL COMMUNITY NETWORK