[AccessD] Database Corruption?

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu Jul 31 16:16:35 CDT 2008


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




More information about the AccessD mailing list