Cannot Delete in a Subform

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

Guest

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