D
DraguVaso
Hi,
I have a table (oas_dochead) for which I have made a View like this on my
SQL SERVER:
CREATE VIEW vw_oas_dochead
AS
SELECT *
FROM oas_dochead
WHERE (cmpcode = SUSER_SNAME())
WITH CHECK OPTION
I linked that View to my Access-application, and in that access-application
I try to delete the records from that View with a Delete-Query like this:
"DELETE FROM dbo_vw_oas_dochead". Unfortunately this gives me the error
"Could not dlete from specified tables".
I tryed alreaddy adding a "UniqueRecords" to my Delete Query, but that
doesn't change anything...
Does anybody knows how to do this? Or can't I delete from a linked View?
Thanks a lot in advance,
Pieter
I have a table (oas_dochead) for which I have made a View like this on my
SQL SERVER:
CREATE VIEW vw_oas_dochead
AS
SELECT *
FROM oas_dochead
WHERE (cmpcode = SUSER_SNAME())
WITH CHECK OPTION
I linked that View to my Access-application, and in that access-application
I try to delete the records from that View with a Delete-Query like this:
"DELETE FROM dbo_vw_oas_dochead". Unfortunately this gives me the error
"Could not dlete from specified tables".
I tryed alreaddy adding a "UniqueRecords" to my Delete Query, but that
doesn't change anything...
Does anybody knows how to do this? Or can't I delete from a linked View?
Thanks a lot in advance,
Pieter