Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Invalid Procedure Call (Access 97)

    Hi Everyone,

    Left([MyFieldName], instr([MyFieldName], ".")-1) worked up until today. The database is located on one machine. The references were checked, removed, and readded. The Linked Table menu does not show any missing links. It also generates the error "invalid procedure call" in a month old backup.

    Does anyone have any ideas on what is causing this and how to correct it.

    Thanks

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Invalid Procedure Call (Access 97)

    I would create a new db, and import all objects from the old into the new.
    Unless you have got security setup it only takes a minute.
    Regards
    John



Posting Permissions

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