RANDALL R ANTHONY
RRANTHON at sentara.com
Fri Aug 1 14:05:52 CDT 2008
Another D'OH! moment... That simple Dcount statement using a query is actually calling the function (after I dug through every field in the query) and apparently the addition of a second query has slowed it down to a crawl.
So, problem found, now I just need to fix it. Thanks to everyone who took a look. Have nice weekend.
>>> "Randall Anthony" <randall.anthony at cox.net> 7/31/2008 7:49 PM >>>
Just parameter stuff, for instance:
Datefield between #7/1/08# and #7/28/08# and AuditType = 1 and BusUnit = 2
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Thursday, July 31, 2008 5:17 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Database Corruption?
If you display CRITERIA in a MsgBox what does it have?
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Thursday, July 31, 2008 12:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Database Corruption?
Grasping at straws, I added that code Don. No go. Just to reiterate, it's
not the that line of code, but that fact that it's jumping to a function
that is not being called from there. It's as if seeing "Claim ID" in the
first line, it's thinking it needs to call that function.
>>> "McGillivray, Don [IT]" <Donald.A.McGillivray at sprint.com> 7/31/2008
>>> 2:59 PM >>>
Dunno if this will help . . .
Sometimes unexpected values in the table being aggregated will cause the
domain aggregate function to puke, so I often wrap them in an Nz() function
to ensure that a valid value is returned. Something like:
If Nz(DCount("ClaimId", "Audit Detail", Criteria), 0) = 0 Then
Might be worth a try . . .
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Thursday, July 31, 2008 11:31 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Database Corruption?
A97, FE and BE
Hey everyone,
I've got another one of those bizarre problems that just cropped up. Made
some extensive changes to a db. During some regression testing a user
reported a problem that the db was getting hung up. Stepping through the
code I found this anomaly:
When the code hits this line
If DCount("ClaimId", "Audit Detail", Criteria) = 0 Then
it jumps to this public function (which is not supposed to be invoked until
way down the line) Public Function ErrorCodeList(ClaimID As String) As
String
When it does this, a) it hangs up because there's a boatload of records, b)
shouldn't be happening.
I finally resolved it (or so I thought) by doing the ol' /decompile switch
on my frontend. Now my test FE and BE work. However, when I connect my
clean FE to the production BE, the same thing happens. I've created a new
db and imported all the tables into a new container, no go.
Any clues would be sincerely appreciated. Thanks!
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com