Gary, did you try to define a field named group_name? I'm not sure why that text is there otherwise, but it looks like a field name without an accompanying field type (such as text(25)).
-----Original Message----- From: Gary Metzler [mailto:[email protected]] Sent: Tuesday, December 01, 2009 6:40 PM To: [email protected] Subject: error when creating a table Hi All, I updated the homer shared object script. But, I am getting an error when I try to create a new table. I am using db dialog 1.1 Here is the error: Error (Dialog) ADO Provider Error Number: -2147217900 (Edit Box) Description: Syntax error in field definition. (Edit Box) Native Error: -538119649 (Edit Box) SQL State: 3000 (Edit Box) Source: Microsoft JET Database Engine (Edit Box) SQL Command: (Edit Box) create table booking (Tagged Text(1), booking_ID Counter Primary Key, Added DateTime, (Edit Box) Modified DateTime, Group_name, Extra_Info Memo) (Edit Box) Close (Button) Any help would be most appreciated. Thanks, Regards, Gary Metzler send to: [email protected] http://www.outtasighttravel.com Msn messenger: [email protected] Skype name: garymetz
