General discussion

  • Creator
    Topic
  • #2092273

    Access 2000 ODBC Problem

    Locked

    by ejensen ·

    Under MS Access 97 Pro, I was able to define a linked table to an IBM AS/400 database without incident. I installed MS Office 2000 Developer, an some but not all AS/400 database will return a Jet error “Invalid scale for decimal data type” when I attempt to define the link. I have updated all of my Microsoft and IBM software. Any ideas?

All Comments

  • Author
    Replies
    • #3878384

      Access 2000 ODBC Problem

      by glen_mcleod ·

      In reply to Access 2000 ODBC Problem

      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

      • #3878362

        Access 2000 ODBC Problem

        by ejensen ·

        In reply to Access 2000 ODBC Problem

        Changing the other system’s database to conform to Microsoft’s current — dream is not an acceptable solution. I thank you for the information because it confirms that which I thought.

    • #3879470

      Access 2000 ODBC Problem

      by glen_mcleod ·

      In reply to Access 2000 ODBC Problem

      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

      • #3868736

        Access 2000 ODBC Problem

        by ejensen ·

        In reply to Access 2000 ODBC Problem

        The database definitions are under anither machine (AS/400) and are being downloaded to Access via SQL (which evidently isn’t very “standard”).

    • #3869534

      Access 2000 ODBC Problem

      by highlander718 ·

      In reply to Access 2000 ODBC Problem

      It has nothing to do with Access2000. I got this message in Access97 as well sometimes. Did you redefined/reinstalled your ODBC after installing MS2K ? Or you just redefined the links in Access ? Are you using Client Access ODBC or Rally ODBC or something else ?

      • #3868737

        Access 2000 ODBC Problem

        by ejensen ·

        In reply to Access 2000 ODBC Problem

        (1)Redefine/reinstall–no, (2)Client Access ODBC. I just ordered a new Cumm PTF from IBM. After researching on IBM Web sight, I found a number of PTF’s that seem to be similar problems but not an exact match. Thanks, I will attempt to remove and re-add the ODBC connections.

    • #3868735

      Access 2000 ODBC Problem

      by ejensen ·

      In reply to Access 2000 ODBC Problem

      This question was closed by the author

Viewing 3 reply threads