Hi guys,
I am pretty new to MS Access but I was able to create a DAP that is being accessed by multiple users at the same time to update a table and everything seems to be working OK however the navigation pane at the bottom of the DAP is showing the incorrect number of records. For example there are only 30 records in the table however the navigation pane in the DAP is showing 116. When you scroll navigate between the records it looks like the same records shows up 3 times. So you have to click over 4 times to get to the next unique record. Is there a way to fix this? The table is fine, and has the correct number of records, however the navigation pane is not. The database and DAP is in Access 97 and must stay that way because they don't have any other versions at work. Thanks in advance for your help.

Regards,



-T