error: updatable SQL

A

AlternaTribe

Hello People's,

can somebody help me??? I have a View in SQL and I link her in Access.
whenever I try to update more than a field, it shows the message:
View "dbo.T_Registro" is not updatable because the FROM clause names
multiple tables. (#4405).

I need a front-end for SQL server for users that are accustomed with Access.
But I cannot leave that they use VBA (I would have to teach programming for
them). But when I link a view of several tables (more than 2) he appears the
error message. if I try to give a manual update it works (UPDATE... SET...).

_________________________________________
AlternaTribe
ICQ#: 15583714
_________________________________________
 

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

Top