G
Guest
I have a link to a text file that is updated daily. I run an append query to
add any new records on the text file into a table stored in my database.
I am attempting to update previously appended records based on a field that
may change on a daily basis. The record remains on the report, but one field
goes through 4 changes through the records duration on the report. (linked
text file)
Example
Day 1 Field 21 = "Prelim"
Day 2 Field 21 = "Prelim"
Day 3 Field 21 = "Submitted"
Day 4 Field 21 = "Finalized"
I attempted to set up an update query that establishes a link beteween a
unique account number on the lilnked text file and the table in my data base.
However, I am receiving an error message stating,
"Updating data in a linked table is not supported by this ISAM"
Am I doing something wrong? Is there a work around?
TIA
Antonio
add any new records on the text file into a table stored in my database.
I am attempting to update previously appended records based on a field that
may change on a daily basis. The record remains on the report, but one field
goes through 4 changes through the records duration on the report. (linked
text file)
Example
Day 1 Field 21 = "Prelim"
Day 2 Field 21 = "Prelim"
Day 3 Field 21 = "Submitted"
Day 4 Field 21 = "Finalized"
I attempted to set up an update query that establishes a link beteween a
unique account number on the lilnked text file and the table in my data base.
However, I am receiving an error message stating,
"Updating data in a linked table is not supported by this ISAM"
Am I doing something wrong? Is there a work around?
TIA
Antonio