Search Key Not Found?????

[martinmike2]

I am getting an odd error. When I run my development copy of my db i
get no errors, but when I run the release copy (exact copy) of the db
i get a "Search key not Found" error.; the development runs in a
folder with all of the back-end files. The release copy runs with the
back-end files in several other folders (for security reasons). The
main form is the one that pops the error, it pulls its data directly
off the table. Is this good practice in a multi-user interface? I
tried running the form off a query but ran across not being able to
update the records, even after setting the record type to "Dynaset
(infrequent updates)"

Any help on this issue would be greatly appreciated.

 

[Bill Mosca]

Have you tried relinking the tables using the Prompt For New Location
option? It could be the links have bad indices.

 

[martinmike2]

Bill,

Thanks for the help, I actually figuered out what the issue was. One
of my forms was corrupted, i rebuilt it and that solved several of my
other problems.

 

[Allen Browne]

That's good news, Mike.

The error is typical of a bad index or pointer.

If it's any help for the future, this is what I recommend as a standard way
to recover a database that has some corruption:
http://allenbrowne.com/recover.html

 

[Bill Mosca]

Glad you found the solution. Too bad corrupt forms don't have some kind of
telltale sign. Sometimes, they still work, but cause problems elsewhere (as
you discovered).