Auto synchronize two tables in access

  • Thread starter Thread starter Amod
  • Start date Start date
A

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!
 
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
 
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.
 
Back
Top