Access Issues

[abaldwin2001]

At our company, we use Access to log our schedules in which we produce jobs. These tables are linked by job numbers (primary and unique key) in which we have the schedules made out by department. Yesterday, the lady who normally does our scheduling called me to tell me that she had "funny symbols" all over one of the fields. When I went into it, I found that in one row of information under one particular department, there was, in fact, what looked like Wingdings in one particular field. When I tried to change this record or even delete it, Access threw an error message up that said "The Search Key is Missing". I proposed that (after an hour of messing with it) we just leave it alone if no data was lost, but upon entering a certain Job Number, she was told that the job number already existed but when she tried to do a search on it, it doesn't seem to find it. This leads me to believe that the "wingdings" are the same job number, but I do not understand why it was translated that way and why it cannot be changed. Can anyone help?

 

[JeremyNYC]

First, make a backup.

Then, record, by hand, any data you have about that row and any related rows.

Then, repair and compact the database.

Then delete the related rows. Then delete the corrupted row.

If that doesn't work, import the tables into another database adn do the deleting. Then delete the original tables (you did make a backup, didn't you?). Then import the new tables into the original database.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.