Solved

Err: Read ID not an index in this table

Posted on 2004-08-14
2
245 Views
Last Modified: 2008-01-09
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.
0
Comment
Question by:Elcruzii
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Expert Comment

by:peterpuscas
ID: 11802666
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
 
LVL 16

Accepted Solution

by:
ahmedbahgat earned 500 total points
ID: 11802938
try to compact and compile the db, also check for any missing references

cheers
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question