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
|
|||
|
|||
" isn't an index in this table.
I am having trouble opening a database. It should go straight to a form in
startup, but instead I get an error message (below) and opens to the database window. However, there are no objects visible in any of the windows, and each time I change tabs I get an error message. If I try to go to the Tables tab, the message is "Operation invalid without a current index". Any other tab and the message is:- " 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 have tried making the system objects visible to see what is there, tried doing a Compact and Repair, tried opening with the shift key held down to disable the startup but nothing helps. I am using Access 97, but have also tried this with a copy in Access 2003 as well. HELP PLEASE! |
#3
|
|||
|
|||
" isn't an index in this table.
Thanks for the suggestion, but I have already tried that. I created a new
blank database, went to import the objects from the old one but the import screen opened with no objects showing, and the same message each time I changed from tab to tab. "John Vinson" wrote: On Thu, 17 Nov 2005 06:36:07 -0800, Paul C Paul wrote: I am having trouble opening a database. It should go straight to a form in startup, but instead I get an error message (below) and opens to the database window. However, there are no objects visible in any of the windows, and each time I change tabs I get an error message. If I try to go to the Tables tab, the message is "Operation invalid without a current index". Any other tab and the message is:- " 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 have tried making the system objects visible to see what is there, tried doing a Compact and Repair, tried opening with the shift key held down to disable the startup but nothing helps. I am using Access 97, but have also tried this with a copy in Access 2003 as well. HELP PLEASE! YOu have a corrupt database - probably corrupt systems tables. See http://www.granite.ab.ca/access/corruptmdbs.htm for suggestions; this symptom is on Tony's list. IIRC you'll need to create a new database and manually import all the objects from this one, Compact & Repair usually can't fix it. John W. Vinson[MVP] |
#4
|
|||
|
|||
" isn't an index in this table.
On Fri, 18 Nov 2005 01:16:03 -0800, Paul C
wrote: Thanks for the suggestion, but I have already tried that. I created a new blank database, went to import the objects from the old one but the import screen opened with no objects showing, and the same message each time I changed from tab to tab. :-{( Hope you have a good backup... Check the database recovery suggested links at Tony's site. Have your credit card ready. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |