link table

S

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
delet record from link table of SQL server 2
Table Security in Access 2013 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Linking tables access - sql server 2005 4
SQL Connection Error with MS Access 7
Linked View causing ODBC Call Failed 1
Connection string problems 2

Top