'<linked table name> isn't an index in this table' error in access 97 database
- From: MickBurke <MickBurkellc@xxxxxxxxx>
- Date: Mon, 20 Oct 2008 20:57:14 -0700 (PDT)
We've got a weird one. A client had his system lockup when he forcibly
rebooted it, he tried to open up their database which has the front
end DB on each of their PCs and the back end on the server.When most
of the users start the database it starts as it should and operates
just fine. When this user opens the database it gives a Runtime error
3015 and reports that "<one of the linked table names> isn't an index
in this table. Look in the indexes collection of the tabledef object
to determine the valid index names."
If I hold the SHIFT key when opening the db, and then try to open one
of the linked tables, I get teh same error without the runtime
reference at the top.
Everything I've found on this error says it's a currupted db, but the
database appears to be fine as it runs on every other system. I also
coppied the front end database from one of the other systems to make
sure it wasn't that one that had gotten currupted and that didn't
help.
Anybody have any kind of suggestiosn for this? It's the company
president's PC that is having the problem so I'm desperate for a
solution!
Thanks for any input.
Mick
.
- Follow-Ups:
- Prev by Date: Re: Link to SQL Server 2005
- Next by Date: Re: importing text file error
- Previous by thread: Link to SQL Server 2005
- Next by thread: Re: '<linked table name> isn't an index in this table' error in access 97 database
- Index(es):
Relevant Pages
|
