Two identical tables

[Guest]

Hi all,

I have two tables "TABLE1" and "TABLE2"

I want to make"TABLE2" contain the exact same fields and info of "Table1"
in addition to some other fields like "Language","Customer type","Remarks"...
"Table1" is updated automatically as it's linked to the inbox of the
outlook.
What i want to do is to by pass the updates (adding the new records to
TABLE2) by clicking on a button or any thing else suitable
Please advise

 

[Arvin Meyer [MVP]]

For the first time, copy Table1 to Table2 (right click and choose SaveAs)

After that run an append query to append new records. What you need to do is
add a field, called "Updated2" or something similar to TABLE1 and set its
DefaultValue property to False. Now after the append query runs, add an
update query to the button code which says something like:

Update Table1 Set Updated2 True;

Your next Append query appends all the records where Updated2 is set to
False.

 

[Guest]

Thank you very much..
But the problem is that i cannot add fields to TABL1 as it's linked to the
inbox of Outlook.

 

[Arvin Meyer [MVP]]

OK, then the task is a bit more complex. You'll need to build a non matching
query (there is a wizard that will help) and append only the non matched
values. The query wizard should open every time you start a new query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Hi all,

I created the append query,and it was agood idea to have the info in table1
,copied to table2,but the problem is that when a new row is created in table
1(a new mail is received),table2 is not updated with the last changes

Can you help,i need that whenever a new record is added to table1,it's added
also to table2
Regards

 

[Arvin Meyer [MVP]]

That requires a database that supports Triggers. Access does not. It can
update 2 tables from a form event, but tables in Access do not support
events. That only happens on a server based database engine that runs all
the time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

If you wish, you can use the MSDE SQL-Server data engine and accomplish what
you want. The server service must still run all the time though.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com