|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 17th, 2010, 07:12 PM
posted to microsoft.public.access
|
|||
|
|||
id is not an index in this table
I have been working with this database for several years. I now have an error
that comes up "id is not an index in this table". I have tried making a new database and importing the tables to start over again. Then it will pop up again. Help! thanks, -- Brent 
|
|
#2
March 17th, 2010, 07:23 PM
posted to microsoft.public.access
|
|||
|
|||
|
id is not an index in this table
Have your also tried a compact and repair?
When does this happen? Can you narrow down the table? It may be that importing the problem table(s) doesn't prevent the problem from being imported. Maybe link to that table in a new database then use a make table query on it to recreate the table with fresh records. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Brent" wrote: I have been working with this database for several years. I now have an error that comes up "id is not an index in this table". I have tried making a new database and importing the tables to start over again. Then it will pop up again. Help! thanks, -- Brent
|
|
#3
March 17th, 2010, 10:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
id is not an index in this table
I now have an error that comes up "id is not an index in this table".
When does it occur? Check the SQL or properties of whatever is moving at the time of the error. -- Build a little, test a little. "Brent" wrote: I have been working with this database for several years. I now have an error that comes up "id is not an index in this table". I have tried making a new database and importing the tables to start over again. Then it will pop up again. Help! thanks, -- Brent
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
