ODBC call failed when Apostrophe is used.

[33216CLC]

I have noticed that I get an odbc error in my program when I attempt to access a record from an access database that has an apostrophe. This seems to only happen with Name fields (First, Last, or Company Names). When I use an apostrophe in any other field, like an address field, this does not happen. The only difference with these fields is that the ones genrating the error are indexed fields.

Any idea how this can be solved?

Thanks