What is the name of the table? Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED]
This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. -----Original Message----- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: 20 September 2002 17:18 To: CF-Talk Subject: Access Question I'm having a tough time with an access query. I'm sure it's something simple, but I had shoulder surgery yesterday so I have a ball pumping goodies into the shoulder at it's own discretion. :-) INSERT INTO subdir VALUES ('#good#') And the table is: subdir_id (autonumber) subdir (text) The error says: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same. SQL = "INSERT INTO subdir VALUES ('AAAA')" I know this should work. This db WAS an Access 97 that I converted to Access2002. Could that be affecting it? I've looked at other queries that work like this with autonumber primary keys. Should I just go lay down or what? ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists