Recordset is not updateable - One table Access 2007, other table SQL
Posted on 2009-05-14
I want a simple form where users can edit contact information. All of the information, except customer name, is stored in an access database that is linked to this front end. However, the customer name is on our SQL server and is joined into access via a linked table that is not updateable from Access. I do not want the user to be able to change the customer name, but I need it there for display purposes. The record source for the form is simply:
SELECT Contact.*, dbo_slcdpm.fcompany
FROM Contact INNER JOIN dbo_slcdpm ON Contact.CustomerID = dbo_slcdpm.fcustno;
Any advice on how to make this work would be greatly appreciated.