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." > > > > ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
