Problem deleting a record in a SQL Server linked table!

message from Nuno Almeida on 12 May 2004
Hi,

Sometimes, when I try to delete a record in a SQL Server linked table,
through a Microsoft access form, I get the following error message: "The
command or action '|' isn't available now.@* You may be in a read-only
database or an unconverted database from an earlier version of Integrated
Management.
* The type of object the action applies to isn't currently selected or isn't
in the active view"!

The thing is, next time I press the delete button (The executed command is:
"DoCmd.RunCommand acCmdDeleteRecord"), it works fine...

This seems to be a totally unpredictable occurrence...

This happens, with a single user connected to the database....

Thankx,

Nuno Almeida
 

Archived message: Problem deleting a record in a SQL Server linked table! (MS Access Database)