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 -----Original Message----- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] 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 -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:19 AM To: CF-Talk Subject: RE: Slightly OT: Altering access tables in CF... No problem here...CF 4.5.2, Access 2000 Rick -----Original Message----- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:02 AM To: CF-Talk Subject: Re: Slightly OT: Altering access tables in CF... Yes >>> [EMAIL PROTECTED] 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 [EMAIL PROTECTED] (256) 842-8342 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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