[posted on comp.databases.ms-access]
[posted on microsoft.public.access.adp.sqlserver]
Before saying anything more, I'm sorry for cross-posting, but the topic should
be relevant for every newsgroups I posted in.
A form based on a view from a SQL Express instance ('cause it's a view, it
has no parameters).
The view contains two INNER JOIN.
Trying to add a record from the form, I get the following error (it's an
error message translated form italian to english):
"Input parameters values are invalid. Check status values for more information."
I thought the problem are the two JOIN (read: SQL doesn't know which table
has to receive the record addition), so I changed the form data source, substituting
the view name with a SELECT statement (SELECT * FROM table ORDER BY field).
This way I was able to add records from the form.
I noticed also that it was successful also if I modify form data source substituting
the above SQL statement with the SQL statement contained in the view.
What's wrong in all this?
Don't I have to use a view as form data source?
Do I have to create a stored procedure?
Do I have to change the view anyway?
PBsoft di Gabriele Bertolucci