[AccessD] Database Corruption?

RANDALL R ANTHONY RRANTHON at sentara.com
Thu Jul 31 13:31:19 CDT 2008


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!



More information about the AccessD mailing list