---

Using Dreamweaver ultradev and MS access.
Success with displaying records from data source, no problem.

I am trying to edit and creat records, with zero luck.

I've attempted with dreamweaver's asp language, as well as Coldfusion.
I get similar error top below, with different line number:
--------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/admin/Default.asp, line 245


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Page:
POST 111 bytes to /admin/Default.asp

POST Data:
idfam=2&family=DK90314&desc=Demo+Kit+for+MLX90314&features=w&gendesc=w&categ
ory=Hardware+and+Demokits&keyword=w
--------------------------------------------------------

I have a hunch my db is not configured properly, since 2 separate asp
platforms both puke at the UPDATE command.

Can some one pls tell me exaxly how to prepare a ms DB?

thanks,

Chad

---

"Chad Pepin" <cpe@melexis.com> wrote in message
news:u1vpt2o6t8ta11@corp.supernews.com...
> Using Dreamweaver ultradev and MS access.
> Success with displaying records from data source, no problem.
>
> I am trying to edit and creat records, with zero luck.

Can we have a look at the UPDATE statement?