<font face='Verdana'>I have noticed that in DreamWeaver MX the insert record code is differnt than in UltraDev 4. In addition I can't get the insert record live object to insert a record into an MS Access Database. I test my connection which is good and I can display records.

I have also noticed that if I leave the enctype blank I receive a 500 internal sever error and if I put "multipart/form-data" in the page just reloads, but does not redirect or insert a record.

In UltraDev I never had any problem at all. Can anyone offer suggestions?</font id='Verdana'>

I'm using the built-in PHP server model and sometimes I get the following message, when trying to insert data into my table:

You have an error in your SQL syntax near ''col1', 'col2', 'col3', 'col4', 'col5'' at line 1


I have created the table anew in my database and I have tried to make the page from scratch, nothing seems to work. Although another page with form to insert into another table works fine. I can not tell any differences in those pages except for the col names and values part. What gives? Has anyone had that kind of problems?

Less is more1