'id' is not an index in this table

[DManders]

I have recently moved from Access 03 to Access 07 (yes, I know but I am always behind the times!) and since then I have had loads of the above messages when I open my files. If I hold 'escape' these eventually clear and I can use the file as normal until I exit. How do I get rid of these messages/clear the junk?

[nick404]

Go into table(s) design view and check to make sure that 'id' is still your pk and that it has an index. I don't know anything about upgrading access versions or how well databases update with it, but maybe the indexes got deleted in the process.
Check by (in tbl design view) in the ribbon click 'Indexes' and see if 'id' is in the index pop up. If not make an index for it.

[DManders]

Thanks for that. It seems to have solved some, but not all, of the problems if I delete the blank line under the index properties.

[nick404]

What other problems are occurring? Do you have multiple tables? Might want to check them all

[DManders]

Thanks for your help. I have given up on '07 and reverted to '03 (with '07 reader compatability) and this has cured sall problems...