Index problem.. Help! 1

[jhribar]

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..

 

[Tim1]

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

 

[jhribar]

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..

 

[Aivars]

Hi!
When I have some crabbed problems with databases I create new blank database, open it, then import all database objects from the old database. After that must be verified references on the module code window.

Aivars