Strange Problem II

[Martyh]

Refering to the enclosed graphic, the computer is right about it missing tblTransaction12 !!

I used a dummy table to test out everything till it worked well (tblTransaction). Then in a table I called tblTransaction12 I placed all the proper data. I then changed the name back to the original tblTransactions; redid all the relationships between tblTransactions; and I decompiled and recompiled the code. (Did I miss anything??)

However, I still get this routine recognizing tblTransaction12 which is now removed.

Stangely it recognizes the correct relationship between tblTransactions and tblBudgets, but does not recognize the relationship between tblTransactions and tblInvoices.

How is this possible?? I am losing hair over this (which will not be the only thing I'll lose if I don't get this thing corrected) Can anyone help me??

and

 

[RuralGuy]

There is Compact and Repair and then importing everything into a fresh, new mdb that has Tools>Options...>General Tab>Name AutoCorrect turned OFF. The problem may not follow the import and it only takes a few seconds to try it.

 

[Martyh]

Problem II --- reprise

Thanks ! I tried that in my office and it didn't work! But I came into the clients site next morning (where the computers are "live") and overnight it must of "repaired itself" because the problem had entirely disappeared!!!

I really can't explain it!

Marty

still

 

[RuralGuy]

I hate it when problems go away on their own. They are just a likely to return on their own as well.