Slightly OT: Altering access tables in ColdFusion

I am getting an error when I try to alter an Access table in CF.  Has anyone had any success doing this?   Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC brian.yager@redstone.army.mil (256) 842-8342

Yes >>> brian.yager@redstone.army.mil 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF.  Has anyone had any success doing this?   Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC brian.yager@redstone.army.mil (256) 842-8342

No problem here...CF 4.5.2, Access 2000 Rick Yes >>> brian.yager@redstone.army.mil 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF.  Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC brian.yager@redstone.army.mil (256) 842-8342

Did you have to do anything special?  Here is my SQL Alter table index_tbl add(pic_pos number) I've also tried with number(1) but still doesn't work. Brian No problem here...CF 4.5.2, Access 2000 Rick Yes >>> brian.yager@redstone.army.mil 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF.  Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC brian.yager@redstone.army.mil (256) 842-8342

OH, I'm sorry, Brian, I misread your statement. I was reading as altering *info* in Access tables, not altering the table itself in the way you're trying to...haven't done that, so I don't know what's possible...sorry. Rick [mailto:brian.yager@redstone.army.mil] Sent: Monday, September 30, 2002 12:15 PM To: CF-Talk Subject: RE: Slightly OT: Altering access tables in CF... Did you have to do anything special?  Here is my SQL Alter table index_tbl add(pic_pos number) I've also tried with number(1) but still doesn't work. Brian No problem here...CF 4.5.2, Access 2000 Rick Yes >>> brian.yager@redstone.army.mil 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF.  Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC brian.yager@redstone.army.mil (256) 842-8342

Back when I worked with Access regularly I used to do it a lot... You might want to forward the particular query and the error to the list. ----- Excess quoted text cut - see Original Post for more -----