Index Errors in Access 97 tables

[Arnold]

I have an Access 97 database that is made up of a front end and a back end, both in Access 97. Just the tables are in the backend. I then link the front end to the backend with linked tables. Next I make an MDE file out of the front end. I have about 10-15 concurrent users at any one time. Here is an error that I get about once per week: I have a Purchase Order table sorted by the PO number and the item number, when I view the table it appears to be sorted correctly, but when I do a findlast of certain PO numbers, it doesn't bring back the last one. Even if I sort the table again, it still doesn't work. However, if I repair and compact the tables, it works again and it finds the last PO number. Any ideas on why Access would be doing this?<br>
<br>
Thanks for your help!<br>
<br>
Arnold<br>

 

[elizabeth]

The memory is very vague but MS did mention something similar in one of the patches, I think it was SR-1 or SR-1. Have you applied them?

 

[Arnold]

Thanks for the input, but I have already installed both SR-1 and SR-2 and they didn't fix the problem. Any more ideas? Thanks for the help.<br>
<br>
Arnold<br>

 

[elizabeth]

This may be totally off but I was just wondering if what you mean by &quot;last&quot; and what Access means is the same thing. My understanding is that when Access compacts a table, items marked for deletion are deleted and this sometimes means previously-used autonumbers become available again, if no following number remains. In other words if you have 123456789 and delete records 2 and 5 and 8 and 9, 8 and 9 now become available for use. <br>
<br>
My only other guess is the index is getting corrupted somehow. You could try deleting and recreating it.<br>
<br>
Good luck