BTW, that *WAS* a problem.... I could use password just fine when entering queries directly into access, but once I changed it to "pword", I no longer had problems.
Still... this is why I frakkin' *HATE* Microsoft Access. Error messages aren't worth crap. Rick On 3/14/07, Rick Root <[EMAIL PROTECTED]> wrote: > > On 3/14/07, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > > > Without looking at anything else, password is a reserved word. > > > > I actually handcoded a query with the password field in it, and ran the > query in Access directly, and it worked.. so unless the database driver is > rejecting it.... that seems unlikely. > > Rick > -- Join the Open Source Coldfusion NCAA Pool for a chance to win a 2 gig USB flash drive! http://www.opensourcecf.com/forums/ncaapool.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

