Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL View not updatable because the modification affects multiple table

Status
Not open for further replies.
kayek

kayek

Programmer
Jun 19, 2003
95
0
0
US
In my Access Database, I am linked to a SQL Server view. The SQL Server view uses multiple SQL Server tables. I get the following error message when I try to update muliple fields in the view "not updatable because the modification affects multiple base tables."

I can update multiple fields in the view in SQL Server buy not when it is linked to Access Database.

Is there anything I can do to resolve this?

 
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
122
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
128
dhookom
dhookom
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
126
TomSalvato
TomSalvato
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
63
dhookom
dhookom
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
65
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top