Updatable SQL queries

C

CS

Hi, I have converted the backend to Sql. Now I am facing a problem. I have
created some Pass through queries and I use them as the recordsource for the
forms. However I am not able to edit any forms as it gives me this message on
the status bar that the "Recordset is not updatable". Please help.

Thanks
 
R

Rick Brandt

CS said:
Hi, I have converted the backend to Sql. Now I am facing a problem. I
have created some Pass through queries and I use them as the
recordsource for the forms. However I am not able to edit any forms
as it gives me this message on the status bar that the "Recordset is
not updatable". Please help.

Thanks
Click to expand...

Sorry, a Passthrough query is always Read-Only. Have you tried linking to
the tables and binding your forms to the links?
 
Top