Problem deleting a record in a SQL Server linked table!

N

Nuno Almeida

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top