×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Index problem.. Help!

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!

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

RE: Index problem.. Help!

(OP)
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..

RE: Index problem.. Help!

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close