Inconsistent query results in Access 2000

[rwwilliamson]

I'm running a database with approx 17k records of data that is associated with 2k records of users. My concern is that when I run a VBA-based calculation to extract the top 4 records for each of the users that I do not get a fully repeatable result. I have created an exception check and between 5 and 8 users have different result summaries for each calculation update. The data tables or queries look correct, the records appear to all be uncorrupted and yet the results are not repeatable. I have tried "compact and repair" without improvement. Is there a tool to check the integrity of the database - particularly the fields in the 17k record table? Windows 2000, Access 2000 Sp3. All MS upgrades are in place. P4 with 2G ram, Intel motherboard. I'm nearly at my wits end so any idea will be appreciated!

 

[WIS]

I'm running a database with approx 17k records of data that is associated with 2k records of users!

Could you give a brief rundown of what the critical flds, in particular the join flds, are in the tbls.

Access 2000 Sp3

Have you applied the "hotfix" as yet. Site is http://support.microsoft.com/kb/945674