The Search Key was not found in any record

B

BJ Perry

I created a small application in Access 97 or 2000, I
can't remember which one.

I have several linked "tables" to dBase III+ files called
Moe.dbf and moecust.dbf.

I set a relation based on a common key called cust_code.
I can create a query to each table indivually with no
problem. However, when I try to create a query using
both linked "tables" I get a message "The search Key was
not found in any record".

I have gotten the latest Service patches to both Windows
XP Pro and Windows 2000.

I am running Acces 2000 and Access 2002 on my XP Pro
machine and I get the same message. I also get the
message on a machine running Windows 2000 (with all
current SP's installed) running Access 2000.

I have installed 282010 Hot fix as called out in
KnowlegeBase article 282010.

I have played with this for several days. From what I
can determine from searching aroud it looks like the
Access program was created with an early version of
Jet4.0 which KB 282010 is supposed to fix but it
doesn't. The Jet Update supposedly is contained in
282010.

I'm real desparate at this point. I could sure use some
help.

Thank you,

BJ Perry
tel: 603-668-3215 Ext. 15
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top