What I really want is to use a left join on Table1-Table2 and an inner join on Table1-Table3. But in the sake of criosity I have tried all inners and all lefts, the results being the same. But the ORDER in which the joins are specified in SELECT statment of the recordsource for the form does...
I thought that this was one of the improvements offered by the CDM in Access 2002 - the ability to modify all fields in a multi-table view. Then again, I guess I CAN modify the fields, it is only adding (insert) that causes the problem. Also, I have tried and found that I can get this to work...
Thanks for the ideas, and the answer to your question is "it depends" (wouldn't you know it). If the form datasource is a SELECT statement, then yes, this is the error message. If the datasource is a SP that selects the data, then the error message is the "You can't update the record because...
Originally (as in the .mdb where this works) I did use the ClientID field as the PK in each of the three tables. However, when this did not work in the .ADP with SQL, I did try your suggestion. In my test, I made 3 tables.
Table1 is
ClientID (int, PK, identity),
Data1 (varchar).
Table2...
Hello. I have been using Access for some time, but am very new at using .ADP projects with SQL Server. I have a form which works in every respect, except for when I try to add a record. I am using Access 2002 and SQL Server 2000. I "upsized" my .MDB project. A simplified example will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.