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?

Thanks for your help!

Arnold

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?

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.

Arnold

This may be totally off but I was just wondering if what you mean by "last" 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.

My only other guess is the index is getting corrupted somehow. You could try deleting and recreating it.

Good luck :)