Is it possible that their copy of the db has a typo in one of the column names, or is missing a column or mis-defining a column? Can you try a dsn-less connection running the script on your server, but calling the database on their server via the IP? ..my 2 shots in the dark. -----Original Message----- From: Edward George [mailto:edward at suppose.co.uk] Sent: Tuesday, March 26, 2002 8:06 AM To: thelist at lists.evolt.org Subject: Re:[thelist] Updateable query? ASP DSN-less access connection This is a multi-part message in MIME format. -- [ Picked text/plain from multipart/alternative ] They're pulled out of a form, here's a test one INSERT INTO Events (Headline,Body,ImgLink,ImgPrevLink,ImgAlt,Entry,Expiry,Descr) VALUES ('test','test','test','test','test','test','29/03/2002','test') All fields are text apart from Body which is a memo. As mentioned it breaks only on their server but works fine here. thanks Ed, ed at suppose.co.uk http://ed.suppose.co.uk http://www.suppose.co.uk Paul Backhouse Tue Mar 26 06:55:01 2002 I would need to see what your queries are. -- -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt !