Good Morning all
I have an access database that's published to sharePoint services. The database contains one table. We used Microsoft's 'Assets Database' Template to initially set it up. I've changed quite a bit around in the template to make it fit our needs, and things seem to be coming along just fine for the most part. But like my post states.... TOTAL NOOBIE to Access.
My question is:
We used auto numbering for each record, the auto number is the first field in the database ( I believe this is my primary key as well). when a user deletes a record - say record 4 for example - the database does not renumber the records it just shows the records in order as 1, 2, 3, .. , 5, 6, etc... skipping number 4. So this puts my users in a position where they have no idea how many actual records are in the database. Is there a way to have access re-number the records? I assumed when I setup auto numbering for column 1 that it would do this.
Thanks!