Gary Kjos
garykjos at gmail.com
Thu Sep 21 08:02:27 CDT 2006
Always odd when something works on one system and not another. I would try to change the update query to a select query temporarly and export that to a text file to see just what exactly it is trying to add. Could be a number of decimals issue with a numeric field too. Or if not a select query, how about a make table query to a temp Access table so you can see what kind of fields access thinks it requires and compare that to what you have in the SQL table. I assume that you have compacted and repaired the app on the failing machine? Rebooted the failing machine? all that standard stuff we do when weirdness is encountered. Good luck with it Erwin. GK On 9/21/06, Erwin Craps - IT Helps <Erwin.Craps at ithelps.be> wrote: > > I got a strange problem. > > I have an update routine that updates articles and prices in my webshop > (SQL server) from my Access database (MDB 2003). > Its a plain Update query that updates prices and descriptions that I > first downloaded and processed from my supplier. > This routine gets executed every night running Access 2K3 on my W2K > server. > Since a week or so, I get every morning a error 3163, > "The field is too small to Accept the amount of data you attempted to > add. Try inserting or pasting less data." > It is posible that a new article has got a longer descriptiontext, so > I'm trying to find where the problem is. > > And now the odd thing, when running the same database and query on my > notebook computer the query runs fine without any error!!! > > So I don't understand why the same database(s), same query runs fine on > my notebook computer and fails on my server. > > > > > > > Erwin Craps > > Zaakvoerder > > > > Nieuwe internetwinkel op www.ithelps.be/shop > <http://www.ithelps.be/shop> > > www.ithelps.be/onsgezin > > bezoek ook eens de website van mijn zus www.friedacraps.be > <http://www.friedacraps.be/> > > > > This E-mail is confidential, may be legally privileged, and is for the > intended recipient only. Access, disclosure, copying, distribution, or > reliance on any of it by anyone else is prohibited and may be a criminal > offence. Please delete if obtained in error and E-mail confirmation to > the sender. > > IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg > > www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be > <http://www.boxoffice.be/> * www.stadleuven.be > <http://www.stadleuven.be/> > > IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven > > IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: > Info at ithelps.be > > Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: > Staff at boxoffice.be <mailto:figures at boxoffice.be> > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com