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!
another table in the same DB when one table gets updated?
Thanks in advance!
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!
Jeff Boyce said:Amod
I'll echo Piet's comments ... why? What business need are you attempting to
solve by having the same data in two tables in the same DB? This is
redundant, uses extra space, and risks your data integrity.
If you'll explain a bit more specifically about your particular situation,
folks here may be able to offer more specific suggestions.
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Amod said:I agree with you Jeff, it is data redundancy but I am really stuck into
this:
Actually I am importing a SharePoint list which creates a table inside
Access, now this table(being a linked 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.
OR
let me put my problem into other words:
I have two tables in a Access 2007 database: 1st (Linked with Infopath
forms) & 2nd(linked with the SharePoint list). Now the problem here is,
Infopath is not able to link, actually it doesnot even detect the 2nd
table
during data connection.
That is: I have two non-sync tables since Infopath enters some data which
is
NOT going in 2nd table that is why I canot show my submitted data to
Sharepoint List.
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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.