Operation requires an updateable query

B

BAC

XP Pro SP2; MSO Pro 2003

I have an Access DB that ODBC reads a data warehouse and appends the
returned data to an Excel Spreadsheet linked table. Access performs 8
separate reads and appends to 8 distinct worksheets within one Excel Workbook.

When we moved the Access database and its required ODBC drivers to another
user's machine that is "always on" and scheduled it to run daily at 5:00 Am,
the database began throwing the above error on the append queries.

The queries are all similar to:

INSERT INTO autoCommFees ( [Credit App Nbr], [Outstanding Amt] )
SELECT [tblIncomeSubledger to CrApps].CREDIT_APP_NBR,
Sum([tblIncomeSubledger to CrApps].ORIGINAL_AMT) AS SumOfORIGINAL_AMT
FROM (([tblIncomeSubledger to CrApps] LEFT JOIN InComm ON
[tblIncomeSubledger to CrApps].CREDIT_APP_NBR = InComm.Cr_App_NBR) LEFT JOIN
OutComm ON [tblIncomeSubledger to CrApps].CREDIT_APP_NBR =
OutComm.Cr_App_NBR) LEFT JOIN ExcludeSalesRegion ON [tblIncomeSubledger to
CrApps].SALES_REGION = ExcludeSalesRegion.SalesRegion
WHERE ((([tblIncomeSubledger to CrApps].SL_GL_NUMBER) Like "81913520*") AND
((OutComm.Cr_App_NBR) Is Null) AND ((ExcludeSalesRegion.SalesRegion) Is Null)
AND (([tblIncomeSubledger to CrApps].CREATE_DATE)>=[forms]![Sales
Pipeline].[dteyear])) OR ((([tblIncomeSubledger to CrApps].SL_GL_NUMBER) Like
"16402013*") AND ((OutComm.Cr_App_NBR) Is Null) AND
((ExcludeSalesRegion.SalesRegion) Is Null) AND (([tblIncomeSubledger to
CrApps].CREATE_DATE)>=[forms]![Sales Pipeline].[dteyear])) OR
((([tblIncomeSubledger to CrApps].SL_GL_NUMBER) Like "81913510*") AND
((OutComm.Cr_App_NBR) Is Null) AND ((ExcludeSalesRegion.SalesRegion) Is Null)
AND (([tblIncomeSubledger to CrApps].CREATE_DATE)>=[forms]![Sales
Pipeline].[dteyear])) OR (((InComm.Cr_App_NBR) Is Not Null))
GROUP BY [tblIncomeSubledger to CrApps].CREDIT_APP_NBR
ORDER BY [tblIncomeSubledger to CrApps].CREDIT_APP_NBR;

autoCommFees is the Named Range of the table to be appended to in the Excel
Workbook

tblIncomeSubledger is a table created through a make-table query based on a
Pass-through query to the ODBC warehouse;

The InComm, OutComm and ExcludeSalesRegion tables are created and maintained
by the user to force inclusion/exclusion of specific credit applications
(CrApps)/regions that require exception handling.

Even tho the query reads multiple tables (one of the properties of a query
that would make it "non-updateable") the query does run on my machine and on
others, but not on this particular machine. As best I can tell (and my IT
types assure me) both machines are identically imaged.

Any suggestiions on where I might look for the cause of this inconsistency
and how to repair it.?

Any help would be appreciated

tks

BAC
 
Top