If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
The Recordset is Not Updateable
Help! For some reason one of my forms has stopped working in that I can't
change any values in the fields The status bar says "The recordset is not updateable". The form is based on a qry and if I run the qry itself I get the same message when I try to change values. This has worked fine up until now and only stopped working a couple of days ago. I haven't changed the table design at all. The qry is based on three tables all linked by the REFNO field. tblCompany has a primary key of REFNO and EMS and REF have a foreign key of REFNO. If I remove either EMS or REFNO from the qry i can change data but having both causes the error. EMS and REF are both linked dBaseV tables also being used elsewhere. I don't think this is a locking issue because it's been happening for a day or two now. Can anyone help at all? If it helps I can paste the qry here? Thanks Paul |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query: Recordset is not updateable | Mus' via AccessMonster.com | Running & Setting Up Queries | 2 | September 1st, 2005 02:27 PM |
Forms, Tabs, Subforms... Trouble Shoot Non Updateable Recordset | Roger | General Discussion | 2 | June 28th, 2005 10:47 PM |
this recordset is not updateable | Gail | Using Forms | 1 | March 9th, 2005 04:32 PM |
Non Updateable Recordset | Howard | Using Forms | 3 | March 7th, 2005 06:03 PM |
Recordset not Updateable | Howard | Running & Setting Up Queries | 2 | March 7th, 2005 05:55 PM |