Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    97 DB Converted to 2000, then converted back to 97 (Access97 SR-1)

    Access 97 db was converted to 2000, then converted back to 97
    Error started occurring in query.
    2000 (working correctly)
    1) Enter parameter value - Start date
    2) Enter parameter value - End date
    3) Long on to Oracle
    97 Not working
    1) Enter parameter value - Start date
    2) Enter parameter value - End date
    3) Ltrim
    4) Str
    5) Mid$
    6) ODBC - call failed
    Any suggestion on what the problem is on converting back to 97?? Thanks

    <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 97 DB Converted to 2000, then converted back to 97 (Access97 SR-1)

    In a word "references". The problems with built in functions suggest you've got a broken reference. Open a module and select References from the Tools menu. You'll undoubtedly see one MISSING, possibly the DAO or ADO reference.
    Charlotte

  3. #3
    Lounger
    Join Date
    Jul 2001
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 97 DB Converted to 2000, then converted back to 97 (Access97 SR-1)

    Thank-you for your suggestion, currently checking on this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •