Error (no. 2501): The save action was canceled

[polo]

Hi all,

Recently I am getting this message in a database that would allow users to add new rows to tables, even when I look into the tables themselves I can't seem to enter data

Would anyone know what could be causing this error?

Error (no. 2501): The save action was canceled

Thanks

Polo

 

[jkl0]

If you cancel an action query (Append or Delete query) that error will usually come up.
In your error handling routine, you can skip this by checking for that specific error number.

If Err.Number = 2501 Then
    Resume Next [COLOR="Red"]  'Go to next line of code after error[/COLOR]
End If

Hope this helps?

 

[polo]

Thanks jkl0 but I don't think its that because I cannot even update the table manually... when I look to the tables they appear to be read-only... I have check the mdb file it isn't read-only... is there anywhere within access that the database or the object could be set to read only?

 

[The_Doc_Man]

There is an explicit setting for a query to have a read-only property. If the query is an aggregate query such that a record in your query doesn't point to a UNIQUE record in the table (or to a JOIN of individually unique records if multi-table), you cannot update it because Access doesn't know where to put it. You might also have the problem that one or more of the underlying tables is read-only, or that your permissions for the tables or query are read-only (if you have Workgroup security imposed).

Finally, if you have a shared MDB file and you don't have rights to open or update the LDB file in the same folder, you can't lock a record, so Access won't let you modify anything.