When I tried to delete the record, I got a error message! Pls Help

[Guest]

Hi

I have a database which has 2 main tables link together. One is "Project"
table and the other is "PO" table. And I have one form that pulls information
from both tables. Recently I don't know what I 've done wrong. When I put a
new record in the form, it's not update. I mean when I closed it and opened
the form again, it won't show that record but it showed in Project and PO
tables. Then I tried to delete that record in both tables but I couldn't do
it in Project table. I got a message said "The search key was not found in
any record". What cause that problem? If anyone can help me out with this, I
would appreciate. Thanks

 

[Guest]

Ouch. I think that it might be a corruption problem. Make a backup of the
database first then do a compact and repair.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Guest]

Thanks Jerry. Do you know what cause for this problem--corruption problem? I
am a new user for Access. Thanks again for your suggestion.

 

[Douglas J. Steele]

Tony's page lists a number of causes of corruption. Allen lists some at
http://allenbrowne.com/ser-25.html

 

[Guest]

Thank you so much for your information. That's help me a lot. Have a good
weekend.