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 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!
Can someone help me?

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
Linked SQL Tables don't report Cascading Updates and Deletes 2
dbSeeChanges problem in Access with linked SQL Server table 4
SQL Connection Error with MS Access 7
Linking tables access - sql server 2005 4
linking to SQL Server db table 6
Code quits after record delete 4

Top