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
|
|||
|
|||
Cannot Delete in a Subform
I have a Continueous Subform and I'm trying to delete a single row.
I get a confirmation message and click Yes to delete. The record disappears. HOWEVER, the record is not actually delete from the database! Opening the form/subform again shows that the record is still there as before. The setup is a Front-end/Back-end, where the back-end is on another computer or server. This only happens on a few setups, so its not a bug in the program, but something wrong on the system where the program is running on. Edits and additions work just find on the subform. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Cannot Delete in a Subform
Okay, you have several computers, each with their own local copy of the
front end mdb (not a shared one), and connecting to the back end mdb. The failure to delete from this subform occurs only on some computers. If it is consistent with those computers, chances are that they need a service pack. Choose About from the Help menu, and see the version. You should see something like: Microsoft Access Office 2000 SP3 The "SP3" indicates Service Pack 3. What is different with the computers where this fails? You can download the service packs from: http://support.microsoft.com/gp/sp The JET service pack is just as import, though a little harder to discover. If you are using Access 2000 or 2002, go to the machines where this fails, and locate the file msjet40.dll, typically in windows\system32. Right-click it, and choose Properties. On the Version tab, you should see: 4.0.8xxx.0 The xxx digits don't matter, but if you don't see the 8, download and apply SP8 for JET 4. If that does not solve the problem, provide more information about this form. How are you deleting (Del key? command button?) Is the form's RecordSource a table or query? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Yisroel" wrote in message ... I have a Continueous Subform and I'm trying to delete a single row. I get a confirmation message and click Yes to delete. The record disappears. HOWEVER, the record is not actually delete from the database! Opening the form/subform again shows that the record is still there as before. The setup is a Front-end/Back-end, where the back-end is on another computer or server. This only happens on a few setups, so its not a bug in the program, but something wrong on the system where the program is running on. Edits and additions work just find on the subform. Any help would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form, Subform, Tab key | 2nd_Stage_User | Using Forms | 17 | August 25th, 2006 12:30 AM |
Form data to automatically upldate a field in the subform | Database User | Using Forms | 6 | November 8th, 2005 09:01 PM |
Delete selected records in subform in Datasheet view | DrewTheFather | Using Forms | 1 | August 24th, 2005 05:56 PM |
Subform Refresh Problem (but only with an unbound combo box control) | Barry Skidmore | Using Forms | 1 | December 21st, 2004 01:19 AM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |