D
Dale Fye
I'm being forced to use Sharepoint as a database. Access 2007 and SP 2003
I've developed an Access database that I can use to monitor and update a
sharepoint list.
I've written code to identify records in the db that are not in the list,
and to populate the list with this data, and record the lists (ID) back into
my Access table.
I've written similar code to identify records in the list that are not in
the database, append these records to the database, and update the list
(POC_ID) value with the PK value from my Access table.
My problem is that I am trying to identify those records in the list that
are newer (Modified field is greater than the db_Modified field in my table)
than those in the database. Strangely, when I run a query that updates the
fields in my table from the list, the value of the [Modified] field (in the
list) also changes. To make things worse, although all of the other fields
in my Access table get updated properly, my [db_Modified] field is not being
updated with the data from the [Modified] field in the list.
Anybody know an easier way to synchronize these two tables.
UPDATE [JAED Points of Contact]
INNER JOIN tbl_POCs
ON ([JAED Points of Contact].ID = tbl_POCs.List_ID)
AND ([JAED Points of Contact].POC_ID = tbl_POCs.POC_ID)
SET tbl_POCs.POC_Prefix = [Prefix],
tbl_POCs.POC_Rank_Grade = [Rank\Grade],
tbl_POCs.POC_Last_Name = [Last name],
tbl_POCs.POC_First_Name = [First name],
tbl_POCs.POC_Suffix = [Suffix],
tbl_POCs.POC_Title = [Position title],
tbl_POCs.POC_Phone = [Phone],
tbl_POCs.POC_Email = ,
tbl_POCs.db_Modified = [Modified]
WHERE [JAED Points of Contact].[Modified]=NZ([db_Modified],#1/1/2000#)
--
Dale
email address is invalid
Please reply to newsgroup only.
I've developed an Access database that I can use to monitor and update a
sharepoint list.
I've written code to identify records in the db that are not in the list,
and to populate the list with this data, and record the lists (ID) back into
my Access table.
I've written similar code to identify records in the list that are not in
the database, append these records to the database, and update the list
(POC_ID) value with the PK value from my Access table.
My problem is that I am trying to identify those records in the list that
are newer (Modified field is greater than the db_Modified field in my table)
than those in the database. Strangely, when I run a query that updates the
fields in my table from the list, the value of the [Modified] field (in the
list) also changes. To make things worse, although all of the other fields
in my Access table get updated properly, my [db_Modified] field is not being
updated with the data from the [Modified] field in the list.
Anybody know an easier way to synchronize these two tables.
UPDATE [JAED Points of Contact]
INNER JOIN tbl_POCs
ON ([JAED Points of Contact].ID = tbl_POCs.List_ID)
AND ([JAED Points of Contact].POC_ID = tbl_POCs.POC_ID)
SET tbl_POCs.POC_Prefix = [Prefix],
tbl_POCs.POC_Rank_Grade = [Rank\Grade],
tbl_POCs.POC_Last_Name = [Last name],
tbl_POCs.POC_First_Name = [First name],
tbl_POCs.POC_Suffix = [Suffix],
tbl_POCs.POC_Title = [Position title],
tbl_POCs.POC_Phone = [Phone],
tbl_POCs.POC_Email = ,
tbl_POCs.db_Modified = [Modified]
WHERE [JAED Points of Contact].[Modified]=NZ([db_Modified],#1/1/2000#)
--
Dale
email address is invalid
Please reply to newsgroup only.