"Id" is not an index in this table

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I am using Access 2003 under XP SP3.
I have a main form with 10 sub-forms related to 1 main table and 10
subsidiary tables. Simple stuff so far. For some reason none of my forms will
now open and the error message (really helpful) is <"Id" is not an index in
this table>. I can open all tables and all data appears correct.
There are a couple of simple formulae in calculated fields. I have 5 basic
queries. No rocket science here.
I do not have a field called Id anywhere in the system. I have checked the
table definitions including all attributes. I have removed all but essential
indices. I have checked the remaining indices themselves with the Indexes
function. I have checked all relationships.
I presume that it is the same table that is affecting all reports but that
is tblMain which I have checked and double-checked.
Help!! How do I diagnose the problem if I can't get past the meaningful
error message? I have spent hours on designing and building my forms.
 
Bruce,

I would try creating a new database and importing everything into it. If
all is well then that message might be sign of early corruption. Oh, MAKE A
BACK-UP! <<< That would be step one and two. Then I would open the tables
in the new just to 'peek' at the data and make sure you see no funny looking
characters all is well.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top