Also avoid using spaces in the Column names.
if you continue to have problems, please post a copy of your page so we can see the SQL code that is generating the error.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.