Problem deleting a record in a SQL Server linked table!

message from Nuno Almeida on 13 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! (Microsoft Access Forms)