"Search key not found in any record" Error.

[Qtip23]

Hello Folks,

Ok, so I had to convert my database from 2007 to 2003 because the customer's network on supports Access 2003 applications. When I run my database on the 2007, I do not encounter any problems.

However, in order to save my database in 2003 format. I import the database into a new file save as a .mdb file.

Now when I open my form to make changes to a record and save it. Access will not let me advance any further and gives a "The Search Key was not found in any record".

What does that mean?

Oh, and I also noticed that my SetTempVar macro does not properly import (or at all for that matter).

I have reviewed Allen Browne's website and a few other references but does not seem to apply to my scenario.

Sincerely,
Qtip23

[nico5038]

Ran into: http://support.microsoft.com/kb/301474

Does this help ?

Nic;o)

[ADezii]

I have no idea as to whether or not this applies to your situation, but I had the exact same problem when I tried to make changes to Data in a MEMO type Field. Somehow, this Field had been Indexed, and once I removed the Index, the Search Key Not Found Error disappeared also. Good Luck.

[Qtip23]

Thanks, I reviewed that link Nico. I think it may partially apply. I will review and give it a try on Tuesday to see what happens; however, I do not have administrative rights on my network computer so I may be limited on loading the the latest Jet 4.0 service pack......more to come.

R,
Qtip23

[Qtip23]

I have no idea as to whether or not this applies to your situation, but I had the exact same problem when I tried to make changes to Data in a MEMO type Field. Somehow, this Field had been Indexed, and once I removed the Index, the Search Key Not Found Error disappeared also. Good Luck.

@ADezii I cannot remember if I had indexed the field(s) in question. I will try your suggestion first on Tuesday to see what happens. Thanks,

Qtip23

[Qtip23]

@nico5038 I attempted to recreate the behavior as prescribed by the link but I did not get far as I required administrative rights which I do not have. I dug a little deeper to found out that I had to the correct SP so...I think I am going a different route.
@ADezii I also removed the "index" on all of my fields (except the keys). This did not work either....ultim ately, I want to link this Access Database to SharePoint so I will repost with different question.

That's unless you know anything about linking and automating Access reports to pop up when a user selects a particular SharePoint view?

Thanks,
Qtip23

[munkee]

Qtip I have the same error message appearing did you ever resolve this issue?

[Qtip23]

@munkee I actually decided to go another route. I transferred my database to SharePoint and have been learning about other web based applications. Wish I could have helped you.

Qtip23