Index problem.. Help!
Index problem.. Help!
(OP)
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..
RE: Index problem.. Help!
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
RE: Index problem.. Help!
RE: Index problem.. Help!
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