G
Guest
I have a situation where a few users are experiencing either a lockup or
“Report Cancelled†when trying to run routine reports that have worked for
them in the past. At first it appeared that perhaps there was a problem with
printer drivers since the symptoms were the same as a diagnosed problem with
that as a cause. The situation is this: I promoted a new level of MyApp.mde
(level 6.07) in February. A few users reported having these problems, so I
had them send me their MyApp_be.mdb tables; I could not reproduce the problem
on my machines with either Access 2002 or 2003. I sent them stand-alone
copies of 6.07 in zipped format. They still experience the problem.
So the deal is with the same data and same level of MyApp.mde, we get
different results. I have been unsuccessful in helping them install
MyApp.mdb on their machines (ActiveX problems I don’t know how to fix). I
have imbedded trace lines in the code and had them run it while on the phone
with me. The trace gets us to the point that one of the application fails to
run a query used to post summary data to a table that reflects the monthly
totals by Asset/Fund/Year/Month, from which I extract the Asset and Fund
Balances for a pseudo-Balance Sheet report which includes January 1 opening
balance, Current Month Opening Balance, Receipts, Disbursements, and Current
Month Closing Balance.
In order to get the users back on their feet, I have sent them the Year-end
2006 level of the program 5.30, re-numbered to 6.01 for internal reasons;
they can get the reports using that level.
I attempted to walk two of the users through the displaying of the Database
form, and had them run the queries; one gave up in frustration. With the
other user, we got to the point where a first query qGiftFundAssetTotalsAll
summarizes all donations (income) at the Year/date level by Income Account
and calculates the GiftMonth for later use. This runs properly for them.
The second query, qIncomeByAstFundMoAll uses the qGiftFundAssetTotalsAll
query to sum all Income accounts together by Fund/Asset/Year/Month for
subsequent posting to the tBalanceSheet table. This is where the process
bombs out, with an error message stating that
qGiftFundAssetTotalsAll.GiftDate produced an error (I don’t have the exact
message; the user is in Hawaii, and I was lucky to have her on the phone for
the hour that it took to get to that point.
I have looked at the last modified date in the query listing in the Database
form, and none of the queries used in this procedure has been changed
recently: the first has a Modified date of 3/2/03 and the second has 4/7/05.
The changes in the intervening releases do not have anything to do with the
queries that are failing.
I have queried the users who are having problems, and the first one to
respond has the same level of MS Jet Engine (4.0.8618.0) that I do….
Question: Is there something that can account for different query results
on different machines, given the same program and data?
I’d appreciate any help!
“Report Cancelled†when trying to run routine reports that have worked for
them in the past. At first it appeared that perhaps there was a problem with
printer drivers since the symptoms were the same as a diagnosed problem with
that as a cause. The situation is this: I promoted a new level of MyApp.mde
(level 6.07) in February. A few users reported having these problems, so I
had them send me their MyApp_be.mdb tables; I could not reproduce the problem
on my machines with either Access 2002 or 2003. I sent them stand-alone
copies of 6.07 in zipped format. They still experience the problem.
So the deal is with the same data and same level of MyApp.mde, we get
different results. I have been unsuccessful in helping them install
MyApp.mdb on their machines (ActiveX problems I don’t know how to fix). I
have imbedded trace lines in the code and had them run it while on the phone
with me. The trace gets us to the point that one of the application fails to
run a query used to post summary data to a table that reflects the monthly
totals by Asset/Fund/Year/Month, from which I extract the Asset and Fund
Balances for a pseudo-Balance Sheet report which includes January 1 opening
balance, Current Month Opening Balance, Receipts, Disbursements, and Current
Month Closing Balance.
In order to get the users back on their feet, I have sent them the Year-end
2006 level of the program 5.30, re-numbered to 6.01 for internal reasons;
they can get the reports using that level.
I attempted to walk two of the users through the displaying of the Database
form, and had them run the queries; one gave up in frustration. With the
other user, we got to the point where a first query qGiftFundAssetTotalsAll
summarizes all donations (income) at the Year/date level by Income Account
and calculates the GiftMonth for later use. This runs properly for them.
The second query, qIncomeByAstFundMoAll uses the qGiftFundAssetTotalsAll
query to sum all Income accounts together by Fund/Asset/Year/Month for
subsequent posting to the tBalanceSheet table. This is where the process
bombs out, with an error message stating that
qGiftFundAssetTotalsAll.GiftDate produced an error (I don’t have the exact
message; the user is in Hawaii, and I was lucky to have her on the phone for
the hour that it took to get to that point.
I have looked at the last modified date in the query listing in the Database
form, and none of the queries used in this procedure has been changed
recently: the first has a Modified date of 3/2/03 and the second has 4/7/05.
The changes in the intervening releases do not have anything to do with the
queries that are failing.
I have queried the users who are having problems, and the first one to
respond has the same level of MS Jet Engine (4.0.8618.0) that I do….
Question: Is there something that can account for different query results
on different machines, given the same program and data?
I’d appreciate any help!