Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Posts
    4

    Red face Unanswered: Error accessing file. Network connection may have been lost

    Hi all out there

    I am receiving the above error in my Access database. i am using Access 2007 and can find nothing on the web to give me a clue as to what is causing it. (plenty relating to 2000 and 2003)

    I have had the client / server database running for over 6 months without trouble and all of a sudden 2 users (out of 4) cannot open the client and I cannot compile the VBA code (on my computer) without this stupid mesage.

    I and the users can "see" the network and can open the mdb file directly.

    I use the accdb file, the users use a accde file.

    i have compaced it, recovered an archived version and recompiled it, all to no avail. This has been happening for around 2 weeks. I have not installed or uninstalled anything around that time nor tampered with any XP settings.

    The only thing I am trying is an update for Office and at present it is downloading a service pack for the .Net framework. I did have some issues with this before (about 9 months ago).

    Please HELP! if you can. Thanks in advance.

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sorry, but it sounds like file corruption to me.

    Good backups are a blessing.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Check the connection string(s) used to connect the front end application to the database. Also, what does happen if you copy the application file from a pc where it works to another one where it does not?

    Have a nice day!

Posting Permissions

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