I am taking over administration of a database created by someone else. They have stuck me with a problem I can't work out right away. When I go in to manage the tables, they do not come up. Instead, and error comes up saying the index cannot be found. I thought it might have something to do with the user permissions, and have found that I cannot get in to the tables through any route I know of. Someone please help! Is there any way to find the index? or to make it so I can access the tables without the index? There is a ton of data in there I need, and can't get to..
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Index problem.. Help! 1
- Thread starter jhribar
- Start date
Hiya,
One way of removing an index (and the re-creating if it is corrupted) is to go into the table design screen and remove all the indexes that way. That should then allow you to see the data (if the index is the real problem).
I would recommend that you backup your database before you do this, just in case any odd things happen (this is Access after all)
Tim
One way of removing an index (and the re-creating if it is corrupted) is to go into the table design screen and remove all the indexes that way. That should then allow you to see the data (if the index is the real problem).
I would recommend that you backup your database before you do this, just in case any odd things happen (this is Access after all)
Tim
- Thread starter
- #3
I wasn't at work before, so I put the major part of the problem.. here's the details.. The guy that set the thing up changed permissions. I cannot open the table in exclusive mode, without a crack program. with the crack program, I get in, but when I try to access the atbles, or any other tab in the menu, I get the error "Operation invalid without a current index". Is there a way to circumvent this issue? I am rebuilding the database, so this isn't a huge issue for future data, but I need to pull the old data.. I'm out of my league on this one..
-
1
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question