How To Run a Query Automatically in Access 2000

[Guest]

I would like to run an Append query automatically each time a new record in
inserted in TabelA. The Append query is designed to insert the newly inserted
records in TableA to TableB without using VB scripts.
What do I need to do so the Append query is run each time TableA has a new
record in it?

 

[Guest]

Shariq,

Sounds redundant to me.

I might be able to understand adding a record into another table that has a
1 to 1 mapping to your TableA, but why would you want to copy the entire
record from Table A into TableB?

 

[Guest]

Dale, There is a 1 to 1 relationship between the tables and it works fine
when I delete a record from TableA. But, when I add a record in TableA, the
record won't get inserted in TableB.
TableA has customer details (including name and ID) but TableB has only
customer's ID and Name.

 

[Walter Steadman]

If you are inputting the information to TableA using a form,
You could have the OnClose event of the form run the following:

CurrentDb.Execute "NameOfYourAppendQuery", dbFailOnError

HTH
Wally Steadman
US Army in Iraq

 

[Guest]

I am not using any forms, the data is entered directly in the table

 

[John Spencer (MVP)]

Then you can't do this if you are using an .mdb. Access plus Jet (.mdb files)
does not support this functionality.

You have to switch to a different data engine. MS SQL or ...