delet record from link table of SQL server

[Symphony]

Hi,All

I created a view in our SQL server database, which in the view I can delete
a record according to the cascade delete relationship. Now, we would like to
do it in Access database, so I created an ODBC link to our access database,
from access database I tried to delete the record as well, I got the error
message:

ODBC-delete on a linked table 'dbo_vwSpecialConcerts' failed.
[Microsofe][ODBC SQL Server Drive][SQL Server]View or function
'dbo.vwSpecialConcerts' is not updatable because the modification affects
multiple base tables. (#4405).

Any ideas to solve the problem ?

 

[Joe Fallon]

1. You are deleting from a View, not a table.
2. In order to do this the View can only have a single table in it. Sounds
like you have more than one table.
There may be a way to use an Indexed view to do this but it is more complex.
3. Why not use a SPT query to delete the correct record?
4. Or link to the table and do it directly?
5. Or run a SP to do the correct delete.

 

[Jess Martyn]

Hello,

Eager Young Minds of Today!

Finding ways to earn money online? Been through some shits which tells you
that they pay you, but they don't?

Than, I want you to take a look at http://www.devang.tk There look at the
bottom of the page, you could see an advertisement of ebay.in. Simply, click
on it and "Register" there and start earning bugs right away!

This works for sure, check it out now.

- Regards,
Jess.