Auto synchronize two tables in access

[Amod]

I am using Access 2007, can someone please help me with how to copy data to
another table in the same DB when one table gets updated?

Thanks in advance!

 

[Tom van Stiphout]

On Tue, 22 Jul 2008 05:55:03 -0700, Amod

This sounds like bad database design. Hopefully not.
You copy data with an Append query. It could perhaps have a WHERE
clause that "looks back" on your form to see which primary key value
should be copied:
....where SomeID = Forms!SomeForm!SomeControl

-Tom.
Microsoft Access MVP

 

[Amod]

Actually I am importing a SharePoint list which creates a table inside
Access, now this table(being a lin ked table) is not been read by Infopath?
Any suggestions?
That is why I was try to create a table which can be read by Infopath.