Error 3800: primary key is not an index in this table

[GBAccess]

I have a series of text files that have been linked into Access for years.
Now I suddenly run into the above error and can't figure out why. If I use
the link-table manager, I receive "Application or Object-defined error". The
source files themselves do not appear to have changed and as long as the
errors occur, I cannot look at the table in design view to try to determine
problems there. Does anyone have any suggestions or direction?

 

[Keithr]

Your message doesn't show in full in the posting title field. Can you embed
it in the body of text. Also, can you state what the underlying links are to
- Oracle, SQL Server, Access, Excel, etc.

 

[GBAccess]

The original error I received is: Subject: RE: Error 3800: primary key is
not an index in this table. This occurs when I try to link a text file
(saved in Notepad) into Access. This has never come up as an issue for me
before and the text files are consistent in format from day to day, so I can
pinpoint why this is happening now. I would appreciate any input. Thank you
for responding.

 

[Keithr]

It looks as if, somehow or other, one of the fields has been designated as a
primary key in the cached design schema in Access. When Access tries to link
the table, it will automatically try to retrieve any designated inex,
particularly a primary key. Have you tried deleting the linked table
altogether and re-linking it from scratch? If that doesn't work, try
deleting the link, compacting the database and then re-link. That should get
rid of any cached information that is interfering with the re-link attempt.

 

[GBAccess]

Thank you for your response. I was thinking like you and did delete the
tables in Access and attempt to re-link them. When I try to re-link using
the "Get External Data" method, I get the following:
'Primary key' is not an index in this table

I just can't seem to figure out where this "index" information is being
stored to remove it or why it's suddenly an issue at all.

 

[debra.martin]

what does this mean
<Name> is not an index in this table. (Error 3800)