|
Home > Archive > MS Access data conversion > April 2005 > delet record from link table of SQL server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
delet record from link table of SQL server
|
|
| Symphony 2005-04-06, 8:04 pm |
| 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_vwSpecialConcer
ts' 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 2005-04-06, 8:04 pm |
| 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.
--
Joe Fallon
Access MVP
"Symphony" < Symphony@discussions
.microsoft.com> wrote in message
news:BE639478-F152-4C20-810F- 158CDF2087D3@microso
ft.com...
> 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_vwSpecialConcer
ts' 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 ?
| |
| Jess Martyn 2005-04-13, 3:25 am |
| 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.
"Symphony" < Symphony@discussions
.microsoft.com> wrote in message
news:BE639478-F152-4C20-810F- 158CDF2087D3@microso
ft.com...
> 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_vwSpecialConcer
ts' 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 ?
|
|
|
|
|