Err: Read ID not an index in this table

Hi,
I'm getting an error message and I've checked to make sure that the field is the primary index in the table.  VB code is rstReads.Index = "ReadID".  The procedure reassigns 'reads' to different readers and uses the read id to determine who the 'read' is currently assigned to.  Need fast answer as to what else could be causing this error.  500 points due to urgency.  Thanks.
LVL 1
ElcruziiAsked:
Who is Participating?
 
ahmedbahgatCommented:
try to compact and compile the db, also check for any missing references

cheers
0
 
peterpuscasCommented:
Hi Elcruzii,

it worked for me ,
I've got the error message only if I didn't had the right index.

can you give more details (more of your vb code) or send me the mdb at marian.puscas@sympatico.ca

Peter
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.