I can run a select and make table query from the statement, so I tried to modify the statement to append from the table created in a make table query thinking the subtotals in the original query were causing the problem. Now, one of my append queries to a table fails saying the "Operation is not supported for this type of object". Because I needed to make some updates to that process, I imported everything into a new Access database, decompiled and recompiled all code, and did a compact and repair to ensure no corruption was in the file. Since a recent Windows and Office upgrade by the firm, we have started seeing intermittent errors that are causing load failure. ![]() My database has a load process that has been executing an append query daily without issue since October of 2020.
0 Comments
Leave a Reply. |