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
|
|||
|
|||
"Operation invalid without a current index"
My database is split into a front end and a back end, with the back end
shared on our LAN. I need to add fields to an existing table on the back end. When I click on the Tables tab I get the message "Operation invalid without a current index". What does that mean, and how can I satisfy the requirement? I have checked LDB viewer and verified that no one else is using the database. I can open the front end and see all the data. All the forms, queries and reports that I checked seem to work just fine. I'm stumped. |
#2
|
|||
|
|||
If you have opened the back end exclusively, the error indicates a
corruption. Firstly, try a compact/repair (under Database Utilities on the Tools menu). If that doesn't work, try rebuilding the database by following the 6 steps for the first symptom in: Recovering from Corruption at: http://members.iinet.net.au/~allenbrowne/ser-47.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "HG" wrote in message ... My database is split into a front end and a back end, with the back end shared on our LAN. I need to add fields to an existing table on the back end. When I click on the Tables tab I get the message "Operation invalid without a current index". What does that mean, and how can I satisfy the requirement? I have checked LDB viewer and verified that no one else is using the database. I can open the front end and see all the data. All the forms, queries and reports that I checked seem to work just fine. I'm stumped. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Composite index - can you mix data types? | Fred Boer | Database Design | 4 | September 15th, 2004 06:44 PM |
Invalid Operation error? | djc | Running & Setting Up Queries | 2 | June 22nd, 2004 11:58 AM |
Indexing - Global refresh/deletion of index marks | Ray Cleere | Formatting Long Documents | 0 | April 30th, 2004 10:46 AM |
Cummaltive/Summarised Item total on a different product vlookup, depending on the description on the operation | John Colling | Worksheet Functions | 2 | February 21st, 2004 03:44 PM |