Hi Gila

Thank you for the prompt response.

That is correct, but the computed field is not being updated via the program, but the fields used to compute that field may be updated.

I originally thought the error was caused by a "SELECT *" statement within the program, which is used throughout.

I am outsourced by this company to fix the database and programs, as you will see by the sql code below, the state of the database and programs is scary. (Note the column names... some of the column and table names literally tell a story).

PubCon.Execute "update autoorders set [Personalisation Department Authorisation] = 'Y'," _

+ "[Audit and Security Department Authorisation] = 'Y', " _

+ "[Personalisation Department Authorisation clock card No] = 'AutoRel'," _

+ "[Audit and Security Department Authorisation clock card no] = 'AutoRel'" _

+ "from autoorders inner join products on product = [product code] " _

+ "where autoorders.bankname like 'absa%' and autoorders.scanned = 'N' And " _

+ "autoorders.reprint ='Y' and products.[print reguarity] = 'A'"

When doing any updates which include the "AutoOrders" table, the error refers to the number of columns within the table.