doesn't seem to work with cf-oledb either...in fact, i couldn't even get it to work in an asp-ado environment... ----- Original Message ----- From: Richard Meredith-Hardy To: CF-Talk Sent: Friday, January 11, 2002 11:41 AM Subject: Re: hair-tearing Jet SQL problem!
In my experience Access via ODBC to CF does not support the DEFAULT clause in CREATE or ALTER table statements. Don't know about an OLEDB connection (I do know OLEDB to Access creates a whole new set of probs eg ODBC date & time formats are not supported). Joseph Thompson wrote: > > I can't wait to see if there is a solution here. I have come up against > this problem again and again. > > I have been able to read the field types with ADO but... modifying those has > been a little mystifying. > I got about this far and then gave up on it. > http://cfhub.com/advanced/ado/ > > > I was reading through the Jet SQL (for Access 2000) > > documentation, and noticed this: > > > > "Note: The DEFAULT statement can be executed only > > through the Jet OLE DB provider and ADO. It will return an > > error message if used through the Access SQL View user > > interface." > > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
