MS Access '97 Help

[21Outlaw]

I get the following error when trying to open a database on a shared drive here at work:

<Database Name> Isn't an Index in This Table. Look in the Indexes collection of the TableDef object to determine the valid index names.

When Googling and searching the MS Help & Support Knowledge Base it pretty much says that its a corrupted database when its not. Another user on my network (my boss) can access it and runs a query from it daily and has been for well over a year. He can open the database no problem, I'm the only one having a problem opening this database.

How could this be?

 

[BadThad]

Does the DB have links to a drive you don't have access to? Sounds like a linked table is somewhere, but you don't have access to it.

 

[21Outlaw]

You are correct, there is a linked table. The linked table refers to this particular database, presumably something within the database. I'm guessing the table that contains the data we're checking against. (Pulling out duplicate records)

I do have access to that drive, I work from there daily.

 

[BadThad]

Try individually opening each linked table (database) individually.

 

[21Outlaw]

Already have. I get the same error.

 

[BadThad]

Originally posted by: 21Outlaw
Already have. I get the same error.

You can open each table individually without error?

 

[21Outlaw]

Whenever I try to open the linked table in the current dB, I get an error as described in my original post Whenever I browse to the dB that is home to the linked table (which is on the same shared drive) I get the same error message as above.

Does that help?

Earlier while at work I was thinking about this:
http://support.microsoft.com/kb/151186/EN-US/ - but in the ReadMe, it doesn't tell you which folder to put the drivers in if you're using WinXP, I guessed and put them in the c:\windows\system32\ folder. No luck there. I didn't even replace any driver's at all. And yes I did put the other .dll in the other directory (which didn't even exist). Any ideas on what to try here?

I don't have admin rights, therefore can't install any programs and can't perform this idea:
http://support.microsoft.com/kb/172733/EN-US/

Any other ideas?

 

[boomerang]

You might try posting in http://www.utteraccess.com or http://www.tek-tips.com.

Both haves sections devoted to Access.

 

[JoeyHall]

Do you need to set up a DSN for the datasource of the linked tables?

If the tables are linked to another DB like SQL or Oracle, you will need to set up a DSN.

Go look at your boss's computer, I bet he has one set up.

 

[21Outlaw]

Yes, I had some User/System DSN's I needed to setup as well. I already did that though, it was part of the troubleshooting.

We did figure out the problem though. I just needed someone with Administrator access to perform this:
http://support.microsoft.com/kb/172733/EN-US/

Thanks for all the help guys!