Problems updating data

If you are getting errors when you try and update or delete data, you can try switching off Safe Update Mode.

When you are using Safe Update Mode, AQT runs the updates within a transaction. This allows you reverse the change of you update / delete more rows than intended. Sometimes there are problems with running an update within a transaction:

• MS Access can give you error Option not valid at this time
• DB2/400 can give you error SQL7008 - (table) in (file) not valid for the operation. This will happen if your table is not being journalled.

The solution to both of these is to switch off Safe Update Mode.