Buffer Overun Error when uploading Search: Solution

The Error:

A Buffer Overun error is displayed when uploading due to the Full Product Descriptions being ticked in the search options & some of those full descriptions are containing more than 2048 characters which causes an error on upload & blocks full descriptions in the search results.

Our Solution

Follow these instructions to create a Query in Access to find all "rogue" long product descriptions. It will tell you which products have more than 2048 characters. You can then adjust them accordingly and get your full descriptions back into the search results-

1. Open Access and open Actiniccatalog.mdb
2. Click 'Queries' on the left and click 'New query'
3. Click 'Design view' and click OK
4. Top left there is a square dropdown box- choose the 'SQL' option
5. Put exactly the line below into the text entry screen, replacing anything already there (note the different types of brackets - very important)

SELECT * FROM [PRODUCT] WHERE LEN([FULL DESCRIPTION]) >2048

6. Click the exclamation mark in the toolbar to run the query


Hope this helps some people with the same Buffer Overun problem.