Re: '<linked table name> isn't an index in this table' error in access 97 database
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Tue, 21 Oct 2008 10:14:08 -0400
I would suggest that you get everyone out, backup the backend, then open it and use Tools, Compact and Repair.
That may be enough, but I'd be inclined to open the frontend, delete the links, recreate them, Compact and Repair it. Then distribute this frontend.
It's the company
president's PC that is having the problem
Ain't it always...
--
Joan Wild
Microsoft Access MVP
"MickBurke" <MickBurkellc@xxxxxxxxx> wrote in message news:931c38c6-b290-4b1f-a373-f6102f80f40d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- Prev by Date: Re: Access 2007 Runtime export to Microsoft Word
- Next by Date: Re: Link to SQL Server 2005
- Previous by thread: '<linked table name> isn't an index in this table' error in access 97 database
- Next by thread: Re: '<linked table name> isn't an index in this table' error in access 97 database
- Index(es):
Relevant Pages
|
