[AccessD] Database Corruption?

Sorry for the confusion, that line runs a query to see if there are any claims, if none, then give an error message, if the count is > 0, open the report.  When the report opens, the second line is of code noted is used in the detail to display the error codes associated with a valid ID.

So, right now, when the code hits the first line, it's jumping to that function, which has nothing to do with the first line.  And it doesn't do it with a "clean" FE and BE.

>>> "Hewson, Jim " <JHewson at nciinc.com> 7/31/2008 2:42 PM >>>
Maybe it was typed incorrectly but the domain function should read:
DCount("ClaimId", "Audit Detail", "Criteria = 0") 
I'm not sure what you're trying to do.  How can the result of DCount be zero when you're looking for a valid ID number?
Please explain.

Jim 
jhewson at nciinc.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 1:31 PM
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 
################################################################################

This email transmission contains information from NCI Information Systems, Inc. 
that may be considered privileged or confidential and is intended solely for the 
named recipient.  If you have received this message in error, please contact the 
sender immediately and be aware that the use, copying or dissemination of this 
information is prohibited.

################################################################################

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com