The Search Key was Not Found...

[KolaKubism]

I've got an A2010 DB. Split DB.
I've got a column in the back end which I would like to make append only.
When I do so, and then open the front end I get the error "The search Key was not found in any record".
If I set the append only property back to No for that column, its fine again!
I've tried compact and repair, still the same.
All searches seem to suggest something to do with excel imports but I've not imported anything from excel to this DB.
Any suggestions??

 

[jdraw]

Perhaps you could post the code that is causing the error.
Not sure exactly what you mean by append only -- is this data entry only?

 

[KolaKubism]

I don't think this is a code issue.
The append only is in the property of the column.
Looking at the table in Design View, click on the relevant column (which is a Memo field), look at the properties at the bottom - set the Append Only property to YES.
Save the BE and then open the FE and I get the search key not found error. It won't let me open any forms on the FE or anything.

 

[jdraw]

What exactly do you want to do/append to this field in simple English? I'm not familiar with Append Only.
I did some googling and found these:

 The name "Append Only" is misleading. 
You can edit the content of such a field any way you want.
 It would have been better if it had been named "Collect Change
 History": you can right-click the field and select "Show column 
history..." from the context menu. You'll see a series of time stamps
 and values.

Kind regards, HansV
www.eileenslounge.com

The append only property basically allows you
 to track history for the field.  With this property set to Yes,
 you can still add, edit, and delete data in the field.
  It just allows you to then right click on the field and choose
 “Show Column History” and see all of the changes that
 have been made to that field.


I took the excerpt below from the following article:

What’s new in Microsoft Office Access 2007 - 
http://office.microsoft.com/en-us/help/what-s-new-in-microsoft-office-access-2007-HA010024185.aspx


 
“Memo fields are useful for storing large amounts of information. 
With Office Access 2007, you can set the Append Only property to 
retain a history of all changes to a Memo field. You can then view a 
history of those changes. This feature also supports the tracking 
feature in Windows SharePoint Services so that you can also use 
Access to view your SharePoint list content history.”


This article also references the Append Only property:

Field Properties Quick Reference – http://office.microsoft.com/en-us/access-help/field-properties-quick-reference-HA010231953.aspx
 

Hopefully that helps!

 
Best Regards,

Nathan O.

Microsoft Online Community Support

 

[gemma-the-husky]

In my experience that error message indicates corruption. Copy the database for safety, and then try and find and fix the problem

 

[gemma-the-husky]

I posted my previous note from a tablet.

I am pretty sure the problem is one of corruption. If you look down your table you may see a record(s) with Chinese characters. This will be a corrupt record.

You need to try and delete this record, but you may not find it easy. You may be able to copy the good records into a new table, and gradually repair it in that way. if it is linked to other records, it may cause knock on problems with those records.

try copying all the records in the bad table into a new table - you will probably fail with the same error. So try and copy a selection at a time, until you can identify the problem record.

Because of this, make sure you take copies before trying to fix the problem, as, worst case, you may end up destroying the dbs completely

Out of interest, what is an append only column? Id this a new feature? why would you want an append only field?

 

[CJ_London]

Out of interest, what is an append only column?

It is actually a memo type field and introduced for compatiblity with Sharepoint. One of the properties for this field is Append Only (from 2007). It means that if the user edits the comment, a history of the changes is maintained by appending the changed value. The result is a single record containing a history of comments, whether new or edited. If I recall correctly, the only additional information is a timestamp, and it is down to user discipline to enter other info like who, outcome, next action etc. - admittedly not always required.

I had a play around with it some time ago but found that a bit like a multivalue field, it is too restrictive and not upsizeable so I keep with the tried and trusted method of keeping comments in a separate table where I can document them properly. The only use I had is if you wanted to keep a history of typo corrections! I guess it may also be useful if using sharepoint, but I don't have much experience in that area.

So far as I am aware there is no way to query the memo field to find a comment relevant on a particular day, you need to use vba code to find the history and display in a control.

With regards the OP's problem, this may be due to changing the append only property after data has been entered so my suggestion would be to delete all records from the table, compact the db and try again.