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

Similar Threads

Problem deleting a record in a SQL Server linked table! 0
Problem deleting a record in a SQL Server linked table! 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Runtime Error 2046, when I try to delete a record in an SQL Server table (through an Access 2000 Int 0
linking to SQL Server db table 6
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Deleting Linked SQL Server Table - Linked as Pass Through Query 1

Top