sorting will not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have based a query on a table of client information. The table is sorted
by unique client number, the query is supposed to be sorted by name. The
query had been functioning well, but all of a sudden I get an error message
if any sort is applied that the record has been deleted, yet with no sort all
of the records are there. I am only trying to sort alphabetically by
lastname then first. I have also tried the buttons in datasheet view, which
are not ghosted, but still record has been deleted appears as an error
message. Please help...
 
I have based a query on a table of client information. The table is sorted
by unique client number, the query is supposed to be sorted by name. The
query had been functioning well, but all of a sudden I get an error message
if any sort is applied that the record has been deleted, yet with no sort all
of the records are there. I am only trying to sort alphabetically by
lastname then first. I have also tried the buttons in datasheet view, which
are not ghosted, but still record has been deleted appears as an error
message. Please help...
Click to expand...

Sounds like you have a corrupt Index on this table. BACK UP YOUR
DATABASE, NOW - you may need it!

Try Tools... Database Utilities... Compact and Repair. If that doesn't
help, open the relationships window; note and delete all relationships
to this table (select the join line and delete it). Open the table in
design view; use the Indexes tool, write down all the indexes and
their properties, then delete them. Compact the database; recreate the
indexes; recreate the relationships.

See http://www.granite.ab.ca/access/corruptmdbs.htm for a discussion
of the causes and cures of database corruption.

John W. Vinson[MVP]
 
Back
Top