|  | Search Key Not Found????? | | |
| | | martinmike2 |  |
|  Posted: Tue Aug 26, 2008 4:56 pm Post subject: Search Key Not Found????? |  |
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 | |
| | Posted: Tue Aug 26, 2008 7:38 pm Post subject: Re: Search Key Not Found????? | |
| |  | |
Have you tried relinking the tables using the Prompt For New Location
option? It could be the links have bad indices.
--
Bill Mosca, MS Access MVP
LINK
LINK
LINK
"martinmike2" <martinmike2@gmail.com> wrote in message
news:8c6e2d60-3dba-4a72-8d4a-d936c7cfe773@v16g2000prc.googlegroups.com...
| Quote: | 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. |
|
| |
| | | martinmike2 | |
| | Posted: Tue Aug 26, 2008 11:42 pm Post subject: Re: Search Key Not Found????? | |
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 | |
| | Posted: Wed Aug 27, 2008 12:45 am Post subject: Re: Search Key Not Found????? | |
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:
LINK
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - LINK
Reply to group, rather than allenbrowne at mvps dot org.
"martinmike2" <martinmike2@gmail.com> wrote in message
news:a8ca21c3-3897-4913-9547-4a4c21a3ef55@e39g2000hsf.googlegroups.com...
| Quote: | 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. |
|
| |
| | | Bill Mosca | |
| | Posted: Wed Aug 27, 2008 2:22 pm Post subject: Re: Search Key Not Found????? | |
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).
--
Bill Mosca, MS Access MVP
LINK
LINK
LINK
"martinmike2" <martinmike2@gmail.com> wrote in message
news:a8ca21c3-3897-4913-9547-4a4c21a3ef55@e39g2000hsf.googlegroups.com...
| Quote: | 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.
|
|
| |
|
|
