Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing File Error Message (2000)

    I have a Purchase Request Form that is currently working great. I have a Create New PR button for the users to click on to add a new PR. On this form I have 2 combo boxes that are synchronized. Everything works. I decided I wanted to make 2 forms, one that shows all current PRs already entered and one for just New PRs. Basically the same form, the 2nd one opens to a new record. So I just copied the form and when I open the form the second combo box comes up with a parameter screen, so I went into the code window to check to see if some of the code didn't copy and I get the following error message:
    "Error accessing file. Network connection may have been lost."

    Why am I getting this error?
    Thanks,
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accessing File Error Message (2000)

    Does the problem persist after the following steps?
    - Quit Access.
    - Reopen Access and the database.
    - Perform a Compact and Repair.
    - Quit Access.
    - Reopen Access and the database.

  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing File Error Message (2000)

    I don't remember if I did it in your exact order, but I did close out and I performed the compact and repair and the same thing. I just tried to follow your steps in the exact order and now that message pops up during the compact and repair, I click OK and it goes to the code window highlighting a report that I had deleted.
    Thanks,
    Deb

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accessing File Error Message (2000)

    I fear that your database has become corrupted. If possible, go back to a recent non-corrupt backup copy. If you don't have one, create a new blank database and import as many objects as possible from the problem database. If one or more objects cannot be imported, you will have to re-create them.

  5. #5
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing File Error Message (2000)

    That's what I thought. Well luckily I learned the backup lesson many moons ago so I do have a backup. Thanks.

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

    Re: Accessing File Error Message (2000)

    One cause of this is having some XP apps installed on the same machine and NOT having Office 2000 SP-3 installed. Take a look at <!mskb=304548>Microsoft Knowledge Base Article 304548<!/mskb> and see if it applies.
    Charlotte

Posting Permissions

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