Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error -1517 (WINXP/ACC 97)

    Has this ever happened to anyone?

    It does appear to be isolated to WINXP machines.
    It only happens when "Unfiltering" the form using Right Click.

    Thanks again !!
    Michael

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error -1517 (WINXP/ACC 97)

    There were some issues with WinXP that were fixed with Service Packs, and there were some problems introduced with later Service Packs that have not to my knowledge been fixed. I don't know of any specific problems in the Filter area that you are having trouble with however. But you might check and see if you have the latest Service Packs for both WinNT and Office 97.
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error -1517 (WINXP/ACC 97)

    Thank you Wendell. I will have my IT Dept check the Service Packs.

    Has anyone had a chance to look at the form and the code? I couldn't find anything
    unusual code-wise or reference-wise. But I'm still a novice and may not have noticed something.

    Have a good week end all !
    Michael

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error -1517 (WINXP/ACC 97)

    I have a form that works perfectly on all PCs with WIN2000/ACC 97.
    On the PCs with WINXP/ACC 97, we get the Reserved Error -1517 message under this condition only:

    When the user Right Clicks and does Filter by form - it's OK. It's when they try to Right Click Remove the filter that's when the
    message pops up, In addition to the message, one of the fields(cboSPECIFIC_ISSUE) gets the #error# in it. When we close the form and look in the table, the record is fine. No #error# in the table.

    I know the -1517 is generic, so I have attached the db for someone to kindly look at.

    I have imported all objects into a fresh db, I have repaired & compacted it.
    Still, this problem occurs. I have FE/BE set up with the FE on the local PC and the BE on the server.
    It works for all but the WINXP folks. (And it doesn't happen ALL the time, just most of the time !!)

    I have checked the references, but I am not sure what could be missing.

    There is a bit of code behind the cboSPECIFIC_ISSUE and the cboTYPE OF ISSUE, but it
    seems to work OK.

    Any and all help is greatly appreciated.

    Thank you all,

    Michael Abrams

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error -1517 (WINXP/ACC 97)

    In case anyone is interested, I did find out that if you delete and refresh the links from FE to BE,
    the problem went away.
    From "Tony" on the MS Access forum:

    ..."when I've added a foreign key to a table in the backend which was inserted into the middle of a
    table. Everything would work fine for days or weeks until the backend was compacted. Then the FE
    would puke with the -1517 error you mentioned whenever that particular table was accessed. But deleting
    the link and recreating the link made it work again."........

    We'll see how long it lasts !! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error -1517 (WINXP/ACC 97)

    Actually, any time you make a change to a table in the back-end, you should relink the table that was changed. Otherwise, Access may get confused, or not know about structural changes.
    Wendell

Posting Permissions

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