A database I created for a client some years ago has a macro which contains
an append query. This macro repeats itself until a condition is met and has
run thousands of times without any problem.
The client has asked that I make the database work for multiple factories.
Without going into too much detail the same macro and append query are needed
in the spin-off databases (one for each factory).
The problem is that the append query will not run in any of the spin-off
databases as part of the macro although the macro itself is unchanged, but
will run in isolation when it performs correctly and gives no error messages.
I have run the macro with SetWarnings ON, but only get the warnings that you
would normally expect.
I have pasted over the macro, the append query and the underlying select
queries from the original database, but to no effect.
Please has anyone any ideas on what is happening? I have spent nearly 2 days
on this without any success.
Many thanks in advance for any guidance offered.