has anyone solved this? I still get this error when using the insert record behavior and retrive ID even though I'm using oledb 4.0 connection string:

Microsoft JET Database Engine error '80040e14'

Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

/mluinew/admin/TMPksqyw14ak4.asp, line 90


An anyone help fix this?

Dot

Try the following article from the Macromedia web site, it may help?

www.macromedia.com/support/ultradev/ts/documents/insert_into.htm

regards

Stefan

Edited by - sesame on 20 Aug 2002 17:26:47