sql server odbc: access link table -- sql server odbc

access link table

Symphony
2/14/2005 4:45:06 PM

sql server odbc: 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).

Re: access link table

Mary Chipman [MSFT]
2/15/2005 5:02:00 PM

It's hard to say without knowing what's in the view, but I suspect
you'll need to perform the update against the base table(s) or create
a view with no joins.

--Mary

On Mon, 14 Feb 2005 16:45:06 -0800, "Symphony"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.