Apostrophe in SQL statement

[Anon]

I have the following variable set:

$body="Jeff's Variable"

I am using ODBC to access an Access db on IIS and PHP4. Everything works great until I issue the following:

UPDATE tablename SET body='$body'

I get this error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Jeff\'s Variable' SQL state 37000 in SQLExecDirect in admin.php on line 220

I think it has something to do with the apostrophe because the error goes aware if I strip it out. I have tried addslashes and stripslashes but to no avail. Any help?

Jeff