'Id' Is Not An Index In This Table Error Help!

Hello, I keep getting this error when opening up a database. What can I check to find and fix the problem? TIA

View Replies


AOIndex Is Not An Index In This Table (Error 3800) - Version: 2000 (9.0)

When I try to open database I'am continuously getting this message (AOIndex..) I can't recover database anyhow. Can someone help..?

View Replies View Related

Run Time Error 3800 'CPID' Is Not The Index Of The Table - Version: 2000 (9.0)


I have a Access database where I need to locate a project depending on the ProjectID, ProjectTitle, First name and LastName.When Iam searching the table with the FirstName or LastName,I create a pointer for that CPID (Contact_Person_ID) I get this run time error saying CPID is not the index of this table.The index works for the other fields in the table Lastname,First Name ..it doestn't work only for CPID.Why?
Here's my code
Function FindingContact(PID As String)
MsgBox "In finding Contact"

Dim db As DAO.Database
Set db = CurrentDb()

Dim rsc As DAO.Recordset
Set rsc = db.OpenRecordset("Contact_Person", dbOpenTable)

Dim rsct As DAO.Recordset
Set rsct = db.OpenRecordset("Prj_Contact_Person_Type", dbOpenTable)

Do While rsct.EOF = False

If (rsct("Project_ID") = PID) Then

'If the located Project_ID has primary ContactPerson then book mark the current pointer P1 If (rsct("Contact_Person_Type") = "Primary") Then
CPID = rsct("Contact_Person_ID")
rsc.Index = "Contact_Person_ID"
rsc.Seek "=", CPID
If rsr.NoMatch = True Then
MsgBox "Contact person not found!"
CurPointer_P1 = rsc.Bookmark
End If
End If

'If the located Project_ID has Secondary ContactPerson then book mark the current pointer P2
If (rsct("Contact_Person_Type") = "Secondary") Then
CPID = rsct("Contact_Person_ID")
rsc.Index = "Contact_Person_ID"
rsc.Seek "=", CPID
If rsr.NoMatch = True Then
MsgBox "Contact person not found!"
CurPointer_P2 = rsc.Bookmark
End If
End If

'If the located Project_ID has Other ContactPerson then book mark the current pointer P3
If (rsct("Contact_Person_Type") = "Other_Contact") Then
CPID = rsct("Contact_Person_ID")
rsc.Index = "Contact_Person_ID"
rsc.Seek "=", CPID
If rsr.NoMatch = True Then
MsgBox "Contact person not found!"
CurPointer_P3 = rsc.Bookmark
End If
End If

End If


Set rsc = Nothing

Set rsct = Nothing

Set db = Nothing

End Sub

Any help would be appreciated.

View Replies View Related

Database Corruption Error "AOIndex Is Not An Index In This Table"

I got this "AOIndex is not an index in this table" error with Access 2000 after replicating a database and storing it in the same network folder. I am not able to open my database now, i am afraid 2days work on my forms is lost. I usually have backup, but the last backup i have is 2 days ago i have made alot of changes to 2 FORMS after that :(

Please anybody have suggestions on how to retrive my forms??? I am really concerned about the forms. I have backup for data and for the reports. Please help me?

View Replies View Related

'AO Index' Is Not An Index In This Table

Last week my hard disk on my old machine corrupted…

It happened half way through entering information on a particular MSAccess 2000 database although I am assured that the failure of the database did not result in the failure of the disk.

The computer would no longer boot up and unfortunately we hadn't taken a ghost image of the disk or made a boot up disk.
In the end we managed to take the hard disk out of the machine - then using a small white pin on one of the disks rear ports change it to a slave by placing a small white plug in two of the vertical pins at the rear of the scsi port we then put it into a vacant port on another computer's scsi bus and got that computer to recognise the disk.

Once I managed to get the disk up and running I copied the file to the master disk and went about investigating whether I could get the database back.

With regards to the database the problem I got immediately prior to disk failure was
-'AO Index' is not an index in this table- and this was still the case when I could see the file again.

I tried compact and repair
I tried copy and pasting / renaming the database
I also tried importing tables from the corrupted database by using a fresh database.

None of these things worked.

Note initially I was getting a Cyclical Redundancy Check Error trying to paste the database from the old slave hard disk to the master disk however this seemed to disappear.

Eventually I set up an ODBC link and was able to export the data into an excel spreadsheet. Obviously all the forms / reports have been lost however this was a small personal database on which had been conducted little design. I also have a similar database into which I can place the information and it wil probably take me about a week to get the data back into a database.

All in all a good learning experience - our network databases are fully backed up and we would just go back to a historical copy if something happened to one of our Access applications. I did a search on the forum and only found one other thread on this - 'AO Index' is not an index in this table - so thought I'd post my experiences.

Would welcome any comments if people have a better understanding of the causes / solutions to this problem.


View Replies View Related

Error 3022 - Duplicate Key/Index

Just when I thought I had my problem licked...

I created a subforum with an updateable query, and this works. I can view the results of the query, modify them and add new records.

However I shortly realized that once I deleted a record (either by some VBA code, or by SQL) that I could not re-add the same record through the subform.

I've made sure that the record is deleted, so there is no duplication of the key.
I've made sure that Index is Duplicates OK, so there is no duplication issues there.

What am I missing?

View Replies View Related

Creating A Table To Cross Index Items In Another Table

How do I create a table that can cross index items in another table. Maybe I am not using the right terms here so let me show a small example.

Say I have a tables of words.

Then I have some entries, all more or less synonyms of each others

Now I want to create a cross-index table, related to the table "tblWords" where I can select synonyms from words already in the table "tblWords", so if I for the word "fresh" add "new" and "clean" as synonyms or entries, if I then go and look at the word "new" it will already have the synonyms "fresh" and "clean", likewise the entry "clean" will then have the synonyms "fresh" and "new".

Kind of a many to many relationship junction table but only with one table!

I hope my explanation have not been to confusing, but let me know if you need a clarification.


View Replies View Related

Linked DB2 Tables: Duplicate Index Error


I am attempt to connect to a DB2 table via ODBC. However, each time I do, I get an error stating that the index already exists (two indexes with the same name). Our IT folks are telling me that this is not the case, and additionally, I am able to connect using ODBC in excel, and I am able to conncet to other tables in this DB. Does anybody know a method by which I could connect to this table? Thanks!

View Replies View Related

Index Error Messages - Version: 2002 (10.0) XP

Is there a way to change the message that is diplayed when a duplicate record is created? I have a field that does not allow duplicate entries and I would like to be more consise in my message to end users.

Edited by: neokrelic on 06.30.04.

View Replies View Related

Index Error - Urgent Help Needed - Version: 97 (8.0)


I tried compacted my database and it errored because there was not enough room on the server (I only realised afterwards)

Anyway, I can open my database works fine etc, EXCEPT when I try to go into the design

" isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names. (Error 3015)

I get the same message if I try to repair

View Replies View Related

Continuous Form, Ordinal Index By Function, #Error

I want the recordnumber displayed on a continuous form. The code below works with the command button, but not afterinsert.

Here's the code: (function GetPosition() is the control source)

Private Sub Command28_Click()
End Sub

Private Sub Form_AfterInsert()
End Sub

Private Function getPosition() As String
If Me.RecordsetClone.RecordCount > counter Then
counter = counter + 1
getPosition = "#" & counter
getPosition = "#new"
End If
End Function

Private Sub numbers()
counter = 0
End Sub

So it should do something like this:

#1 [ctrl 1]
#2 [ctrl 1]
#3 [ctrl 1]
#new [ctrl 1]

But called from after insert only the records on the screen get updated unless I scroll up, so simplified it looks like this:

----------------- top of subform after scrolling up
#3 [ctrl 1]
----------------- top of subform before scrolling up
#1 [ctrl 1]
#2 [ctrl 1]
#new [ctrl 1]

Where else can I put it or how can I modify the code to make it work?

View Replies View Related

I Am Unable To Add An Index To An Index Collection - Version: 97 (8.0)

I'm trying to copy a table, minus a couple fields, so I need to copy the primary keys as well. When trying to add an index from the source table to the new table, it gives me an error saying that the object already exists in the collection. However, the indexes collection has a count of 0. What could this mean?

View Replies View Related

To Index Or Not To Index... That Is The Question. - Version: 2003 (11.0)

Hey again,

I am currently working on creating a database and have a few questions on indexing fields. Primarily, does it speed up or slow down the overall database speed? The reason I am asking is because I read an article somewhere that advised against Indexing because haveing a great deal of indexed values actually slows down a database instead of speeding it up.

The DB I am working on has a loooot of IDs and I just wanted to know if it would be a good idea to index them or not.

Also, if two tables are joined at a foreign key like... lets say... PetID, would it be extraneous to index the PetID field in both tables? If so then in which table should the ID be indexed?

Thanks for looking

View Replies View Related

Index No Duplicates - And Not To Display Error Message - Version: 2003 (11.0)

I have my table set for No Duplicates - but I don't want the error message to display and want the process of entering to continue without the duplicate. How can this be accomplished?i

View Replies View Related

Index Or Primary Key Cannot Contain A Null Value (Error 3058) - Version: 2000 (9.0)

I am currently working on a Access db that tracks properties and owners. It has a many to many relationship between the property and owner tables. It has a subform for "current owners" which I am able to see the current owner(s) of that property, re-assign owner(s) and add additional owner(s). My problem is that when I add a new property through the main form then go to the subform to add an owner I get an error message "Index or primary key cannot contain a Null value (Error 3058)" Does anybody know of a good approach to troubleshooting this error message?

Any help is appreciated !


View Replies View Related

Operation Invalid Without A Current Index. (Error 3019) - Version: 97 (8.0)

Does anyone know how to fix or at least what caused the following error? Operation invalid without a current index. (Error 3019) I have tried reinstalling Access, repairing, compacting and nothing is working. I have also searched the web with no luck on any solutions.

Any help would be greatly appreciated.

View Replies View Related

Index Not In Table Message

I am recieving the following message on a computer

'~sq_fShiftReports' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names.

Now here is why this is very confusing. It is a progrma that is on our shared drive and can be opened by everyone except this one computer. I even tried to save the one I have on my desktop and open that version, but was unable. If someone can help me with this, it would be great. If not the only other solution is to uninstall and reinstall access. (We are using access 97)


View Replies View Related

Creating An Index Using Code? Any Other Way Besides On The Table?

I am pullling data from a query using an unbound form and a query that that uses linked tables. I can not edit the index of the tables, so is there a way i can create a new index for sorting data in a form?

View Replies View Related

Make-table Query With Index

I am creating a table with a make-table query. The only trouble is that I can't figure out how to designate which field will be the primary key. Is there a way to do this...... other than creating the table, then manually going into desing mode and specifying the primary key there? I want this to be automated.


View Replies View Related

Secondly Index In A Table - Version: 2000 (9.0)

Hello, i was asked to midify somthing in mdb
,,,"add po_id as a secondary index in the Invoice table to the index having invoice_id..."
What does it mean?

View Replies View Related

A Problem With .index Property With A Linked Table

I have a linked table to a SQL server table called AllAttendanceEvents.
the AllAttendanceEvents table has index called "AttEvents". I wrote the following code:

set AllAttendanceEvents=currentdb.openrecordset("AllAttendanceEvents")

When it executes the read line statement, it generates the following error:
Operation is not supported for this type of object

Is there any way to get around of this problem with the linked tables?

View Replies View Related

Making Index In Table - Version: 2003 (11.0)

I have table what look like this:
[ip address] [device] [fault reason] [start time] [end time] [channel]
111.111.22 divisi service 12234 12.8.12:00 12.8.13:00 BBC

I have make index for this table whit query1.
CREATE UNIQUE INDEX indeksi ON Table ([IP address], device, [fault reason], [start time], [end time];

This index prevent my INSERT INTO-query not add duplicates into table.

Now I'am trying to do index to the table which prevent INSERT-INTO query to add records which [start time] is older than the tables latest [start time] in table records. How this kind of index should be done?

View Replies View Related

Need To Index A Table From A Macro - Version: 2000 (9.0)

I see a brute-force way to do this (keystroke macros). Any better way to do this?

View Replies View Related

AOIndex Is Not An Index In This Table - Version: 2003 (11.0)

I have read a post in regard to this same error (on an earlier version of Acess), so I hope it is not incorrect of me to ask further questions in regard to the error.

I have had this error on a database recently. Our IT section was able to recover the database from the server's backup, but the data was missing for the full days work on Tuesday.

What I was wondering is if this could cause data loss and how to prevent it happening again?

I don't have the file any longer as the IT department restored over top of it ... so I can't show it to anyone. My Executive Manager is not happy with what has happened and wants to make sure that we can rectify the problem.

Any help would be greatly appreciated.


View Replies View Related

Can Access Index A Table Your Not In? - Version: 2003 (11.0)

I'm a newbie at Access. I need to use the index function in one table but want it to also
pull records with the same primary keys from another table I do not have open on the screen.
Is this possible?

One table has 13K records and 9 fields
the other table has 4MM records and 25 fields.

I tryed pasteing the small files records "On top" of the larger table but
even if I make the number of fields the same, it simply doesn't paste more than one record...

Help would be appreciated....

If all else fails I'm thinking I can write a small VB program to merge the records
of both tables but that would be a headache also....


View Replies View Related

Create Index In An External Table - Version: 2002 (10.0) XP

I have a db full of linked tables. I do not know the type of database the original tables are. I am linked using a program called RealVNC. I can use a make table query to export the data into an access table but I can not figure out how to create indexes in the new tables.

Should I write a function in the new db and call it from a macro in the linked db? Is there a way to build indexes in external tables? Is there a way to include indexes in a make table query?

Any help would be greatly appreciated.

By the way I need to transfer 20 tables each night. My plan is to open a form when I leave the office and have the queries begin around 1am.

View Replies View Related

How Do I Set The Index To An Existing Field In A Table? - Version: 2003 (11.0)


I need to use the existing field "Artikelnumber" in the existing table Articles as the index, how can I do that in VBA?

I can do this easily in the table design mode of Access, just go to "Articlenumber" line "Indexed" and set to Yes(No duplicates) but I want to do this using VBA.

looking forward to hear from you,



View Replies View Related

Index Which Enforces Entry Of Only One Value In A Junction Table - Version: 2003 (11.0)

Can someone please tell me if the following is possible...

Junction table:
EmployeeID (no duplicates)

I would like to create an index, if possible, which limits a record to an EmployeeID, and either a CompanyID or a BranchID.

An employee can either be employed at company "headquarters" (corporate),
or be employed at a branch of a company.

View Replies View Related

Build A One-to-many Table From Record With Index And Many Fields - Version: 2002 (10.0) XP

I have a table which contains many records with a unique field and then up to 25 data fields with varying data in each record. What I want to end up with is a new table with a record for each unique field & one of the 25 fields in the source table. For example: I have a record where the unique field is 001 and data fields 1-5 are 12s,14b,17c,18r,100v, respectively. What I need to end up with is a table that shows:

Fld1 = 001, Fld2=12s
Fld1 = 001, Fld2=14b
Fld1 = 001, Fld2=17c
Fld1 = 001, Fld2=18r
Fld1 = 001, Fld2=100v

....then we'd look at the 2nd record of the source table and do the samething. Unfortunately, not all of the non-unique fields will be populated - maybe there will only be 5 instead of 25 and not necessarily in the 1st five consecutive data fields.

Can anyone help me figure this out?

View Replies View Related

No Unique Index When Creating Table Relationship - Version: 2003 (11.0)

I have two tables:



When I try to setup a relationship betwen the two tables via the email address I can unless I try to set the Referential Integrity to true. Then I get the following error:

"No unique index found for the referenced field of the primary table"

Isn't there an index automatically generated for the primary keys in a table??

Also, I did create a separate index for E_MAIL in Table B with Duplicates OK, and I'm still getting the same error message.

Thanks for any help.

View Replies View Related

Dumping Records Into A Table With Multi Field Index - Version: 2000 (9.0)

I have a table that holds banking transactions that I download from an online bank account. I have a multi field index setup to make it impossible to import duplicates. The problem is that sometimes I have duplicates. ie. A deposit for $5 on 1/1/2006 and then a second deposit for $5 on the same day. My table would stop this from happening. There isn't a unique field from the new records I'm dumping in so what would be the possible solution here? Is there any querie I can run that would list duplicate values from the new records table to the main records table before they're dumped. How do I check for duplicates on multiple fields?

View Replies View Related

How To Get Round Error "index... Cannot Contain Null Value" - Version: 2002 (10.0) XP

Is there any way of placing your own error message in the place of the Error 3058 (index or primary key cannot contain a Null value).

It appears when one doesn't input a value for a required primary key field.

I would rather replace the error message with something the users would understand more, any help?


View Replies View Related

Does Access Use Index For Linked Table ? - Version: Any Version

If one table join with linked table, Access still able to use index to search for joining records in the linked table ?

I qeustion this because as I know, We can not use .Seek method for linked table. I don't know why can not. It implies that Access can not use index ? Because I don't think so. It conflict in my mind.

View Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved