Delete Record -weird behavior

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

Guest

When I delete a record from the form, it appears to be deleted. No error
message is displayed. However, when I close and restart the application, the
record is still there!

After a bit of investigating, it appears the the record is only delete from
the recordset of the form but not from the table (even without restarting).

More details:
It is a linked table. Front End/Back End Setup. One User. Very simple table
(just a few fiels). Form is based on just that table (no joins, no
relationships).

The only code on the form is for the Custom Delete button:

DoCmd.RunCommand.acCmdDeleteRecord

When looking at the table (after the record was delete in the form, but
still appeared in the table), there was a locked symbol (circle with a
diagnol line across the circle).

Environment: Windows XP SP2 with all updates installed. Access XP with all
updates and service packs installed.

This error was only happening on that computer. When the same application is
run on another computer, all works well.

Any help on this most puzzling issue is very much appreciated
 
Israel said:
When I delete a record from the form, it appears to be deleted. No error
message is displayed. However, when I close and restart the application, the
record is still there!

After a bit of investigating, it appears the the record is only delete from
the recordset of the form but not from the table (even without restarting).

More details:
It is a linked table. Front End/Back End Setup. One User. Very simple table
(just a few fiels). Form is based on just that table (no joins, no
relationships).

The only code on the form is for the Custom Delete button:

DoCmd.RunCommand.acCmdDeleteRecord

When looking at the table (after the record was delete in the form, but
still appeared in the table), there was a locked symbol (circle with a
diagnol line across the circle).

Environment: Windows XP SP2 with all updates installed. Access XP with all
updates and service packs installed.

This error was only happening on that computer. When the same application is
run on another computer, all works well.

Any help on this most puzzling issue is very much appreciated
Click to expand...

Maybe the user logged on at that computer doesn't have modify permission for
the back-end mdb file.
 
Back
Top