Updatable SQL queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top