N
Nath
Hi,
I have a table in my DB, vac_posts that is a linked text
file, this text file is from our in-house system and lists
the current vacancies with a unique ID of JOb NUmber. I
have another strictly access table, that is called
tbl_vacancies. I have 2 ways of entering data into this
table one is from this linked text file, the orther is
through and outlook form. What i need to do is delete all
the records in tbl_vacancies that have come from OUtlook
and are contained within the linked file. I have done
this by a join on the job number in both tables and an is
not null statement in the criteria on the tbl_vacancies
job number field. I have a data source field in the table
that has OL entered if they have come from Ooutlook, and
hence the criteria of "OL" is in the data source field on
the tbl_vacancies.data_source field. When i run as a
select query my test record that should come up does, but
when i change to a delete query i get and error message
saying "cant delete from selected tables" I am deleting
from the access table and not the linked, they are just
joined.
Regards
Nathan.
I have a table in my DB, vac_posts that is a linked text
file, this text file is from our in-house system and lists
the current vacancies with a unique ID of JOb NUmber. I
have another strictly access table, that is called
tbl_vacancies. I have 2 ways of entering data into this
table one is from this linked text file, the orther is
through and outlook form. What i need to do is delete all
the records in tbl_vacancies that have come from OUtlook
and are contained within the linked file. I have done
this by a join on the job number in both tables and an is
not null statement in the criteria on the tbl_vacancies
job number field. I have a data source field in the table
that has OL entered if they have come from Ooutlook, and
hence the criteria of "OL" is in the data source field on
the tbl_vacancies.data_source field. When i run as a
select query my test record that should come up does, but
when i change to a delete query i get and error message
saying "cant delete from selected tables" I am deleting
from the access table and not the linked, they are just
joined.
Regards
Nathan.