Hello Bob Sorry I can't help directly with your access problem, but I thought I'd make a suggestion:
Access has a massive processor overhead, so much so that 4 symultaneous connections is enough to grind a processor to a hault. MySql is however completely free and can handle 50,000 connections with no problem. All the best Simon On Jan 31, 2008 6:05 PM, Bob Imperial <[EMAIL PROTECTED]> wrote: > I've been working on something here that I just don't get and am about to > toss access out the window frankly :) I've been running/testing an access > 2003 db all morning and it's been behaving (guess I ought to be grateful eh) > until now, I get the following: > Error Executing Database Query. > The field is too small to accept the amount of data you attempted to add. > Try inserting or pasting less data. > > > The error occurred in D:\WebNew\centers\dump.cfm: line 81 > Called from D:\WebNew\centers\fbx_Switch.cfm: line 76 > Called from D:\WebNew\fbx_fusebox30_CF50.cfm: line 241 > Called from D:\WebNew\fbx_fusebox30_CF50.cfm: line 1 > Called from D:\WebNew\fbx_fusebox30_CF50.cfm: line 1 > Called from D:\WebNew\index.cfm: line 17 > Called from D:\WebNew\centers\dump.cfm: line 81 > Called from D:\WebNew\centers\fbx_Switch.cfm: line 76 > Called from D:\WebNew\fbx_fusebox30_CF50.cfm: line 241 > Called from D:\WebNew\fbx_fusebox30_CF50.cfm: line 1 > Called from D:\WebNew\fbx_fusebox30_CF50.cfm: line 1 > Called from D:\WebNew\index.cfm: line 17 > > 79 : <cfelse> > 80 : <cfqueryparam > cfsqltype="cf_sql_varchar" value="" /> > 81 : </cfif> > > > Which is crap because I've been passing data to it all morning!! Anyone > ever run into this? > > Bob > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3295 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
