7 replies
by glen_mcleod
Sounds like you'll have to change some of your numeric fields to the new Decimal datatype. Access97 probably did an inplicit conversion to the closest datatype available and kept going (the old Evil Type Conversion problem, thankfully it's disapearing in the next version of VB!).
The Decimal datatype can be defined up to 28,28 (precision, scale) and is a lot more precise than other types.
Glen
by ejensen
by glen_mcleod
I meant to change your Access fields to Decimal, which should be a relatively painless procedure. The error you mention is 'invalid scale', so your Access files currently don't have enough scale to accept the data comming from the AS/400. Access97just truncated the data to fit, but Access 2000 won't fo that for you, which, in the long run, I think is a good thing.
Glen
by ejensen
by ejensen
by ejensen
This discussion is closed to new replies.
Trending Software posts
Sort by Trending