[AccessD] Database Corruption?

RANDALL R ANTHONY RRANTHON at sentara.com
Thu Jul 31 15:23:02 CDT 2008


    
If Nz(DCount("ClaimId", "Audit Detail", Criteria), 0) = 0 Then
        MsgBox "There are no claims which meet the specified criteria."
    Else
        DoCmd.OpenReport "Claim Detail Report", acPreview, , Criteria
    End If

>>> "Heenan, Lambert" <Lambert.Heenan at aig.com> 7/31/2008 4:12 PM >>>
Can we see a little more of the code context? At lease the whole
If/Then/Else statement? 

Lambert

-----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 2: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 ( http://www.databaseadvisors.com/ )
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com ( http://www.databaseadvisors.com/ )



More information about the AccessD mailing list