Help with Errors
- Thread starter kbreiss
- Start date
- Local time
- Today, 12:11
- Joined
- Feb 28, 2001
- Messages
- 30,836
Let me get this straight. You aren't opening anything in the table, query, report, or module pane. You are just selecting the overall window pane itself. You get the error anyway.
I wonder if you have a startup form running invisibly underneath this DB. If so, there is an error in it.
Otherwise, I would conjecture - and that's ALL it is - that you might have a missing reference or a damaged .MDB file.
First (simplest), attempt to repair the DB. Do so by running Access without actually clicking on the MDB file. You can use the menu bar's Tools entry to get to the repair and compaction sub-menu. Select Repair of the offending DB as an external file to your process. That is, you haven't opened the DB so there cannot be a hidden form running underneath it.
OK, if that doesn't work, from the modules pane, open any module (including, if necessary, that you would create one). Use Tools >> References and see if any of the listed, checked references are prefaced by "MISSING"
Beyond that, I'm not sure how you got that message. I would interpret it to mean that someone gave an improperly quoted index name to some function that relies on index names. Indexes is a collection in a TableDef, and each Index has a name. You can reference indexes by their names. The error you reported makes sense if you give Access a bad index name. A REALLY bad index name.
I wonder if you have a startup form running invisibly underneath this DB. If so, there is an error in it.
Otherwise, I would conjecture - and that's ALL it is - that you might have a missing reference or a damaged .MDB file.
First (simplest), attempt to repair the DB. Do so by running Access without actually clicking on the MDB file. You can use the menu bar's Tools entry to get to the repair and compaction sub-menu. Select Repair of the offending DB as an external file to your process. That is, you haven't opened the DB so there cannot be a hidden form running underneath it.
OK, if that doesn't work, from the modules pane, open any module (including, if necessary, that you would create one). Use Tools >> References and see if any of the listed, checked references are prefaced by "MISSING"
Beyond that, I'm not sure how you got that message. I would interpret it to mean that someone gave an improperly quoted index name to some function that relies on index names. Indexes is a collection in a TableDef, and each Index has a name. You can reference indexes by their names. The error you reported makes sense if you give Access a bad index name. A REALLY bad index name.
Thanks for the prompt reply Doc-Man...
I'm waiting for all users to get out of the program, but I noticed when I click Tools --> Startup I get an "Operation Invalid without a current index" error Does this help you with any other suggestions?
Thanks again!
Kacy
________
KID AVANDIA
I'm waiting for all users to get out of the program, but I noticed when I click Tools --> Startup I get an "Operation Invalid without a current index" error Does this help you with any other suggestions?
Thanks again!
Kacy
________
KID AVANDIA
Last edited:
It just hit me as well....we had a power outage yesterday late afternoon....I wonder if some files got corrupted...the repair database utility won't work either...I get the same error. Any suggestions
Thanks
________
Vaporite solo
Thanks
________
Vaporite solo
Last edited:
