Well i spent hours and hours but couldnt figure this probelem out

I am querying the database on a variablename that is a string.. it works fine .. but as soon as my varable name has an appostrpohe then the whole program crashes.

LIke i wm ausing the statement

rst.Open"SELECT * from Customers wher CustomerName = ' " & variable & " ';", cnn

If the customer name is say

Kevin it works fine

But when it is
Kevin's

it crashes


any solutions to this problem