Copy contents of one table to another

[Guest]

Hi All,
I am a novice as far as Ms Access is concerned. The problem I
am facing is I am having 2 tables A & B containing the same fields. Changes
made in either of them are reflected in the other. I have added another field
in A. I want to copy all the data in this new entry to the corresponding
entry in B. How to do that? Can anyone please tell me?

Regards,
Harshad

 

[Keith]

Hi All,
I am a novice as far as Ms Access is concerned. The problem
I
am facing is I am having 2 tables A & B containing the same fields.
Changes
made in either of them are reflected in the other.

Why on earth would you want to have such a setup?

I have added another field
in A. I want to copy all the data in this new entry to the corresponding
entry in B. How to do that? Can anyone please tell me?

Use an update query, the help will show you how.

Regards,
Keith.
www.keithwilby.com

 

[Vincent Johns]

Why on earth would you want to have such a setup?

[...]

I'm just guessing why you have the 2nd copy, but if you are keeping a
second Table as a kind of backup, you'd be better off having just one
Table and at times compressing the database and making a copy of it. (I
usually do this in Windows Explorer by copying the database file to a
ZIPped file.) Or, if only that one Table ever changes, you can export
its contents to an archive file and compress the file.

If you are using the second copy to display the data in a different
order or format, you could do that via Queries (for organizing data) or
Forms (for inputting data) or Reports (for outputting data).

It might make sense to have two Queries, or Forms, or Reports, that are
quite similar to each other, but normally not Tables. Duplicate
information in Tables basically wastes space without giving you any
advantage that I can think of.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.