Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Moorpark, CA
    Posts
    104

    Unanswered: Error Message....again

    I'm not getting the following error message when I click on certain command buttons in a form:

    Error Accessing file. Network connection may have been lost.

    Please note that I have been using this form and these command buttons for weeks with no problems and then yesterday I started getting this error. I tried to find the cause/solution on Microsoft.com and it mentions something about a service pack that will correct the problem, but the IT guys here don't think that is the problem.

    Does anyone have suggestions? Have you encountered this problem before?

    Thanks for any help!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Jennay
    I'm not getting the following error message when I click on certain command buttons in a form:

    Error Accessing file. Network connection may have been lost.

    Please note that I have been using this form and these command buttons for weeks with no problems and then yesterday I started getting this error. I tried to find the cause/solution on Microsoft.com and it mentions something about a service pack that will correct the problem, but the IT guys here don't think that is the problem.

    Does anyone have suggestions? Have you encountered this problem before?

    Thanks for any help!
    Yes I have ... Try running a compact & repair. If that doesn't work try importing everything into a new database ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Nov 2003
    Location
    Moorpark, CA
    Posts
    104
    The compact and repair didn't help this problem. I'll try the import eventually, but I actually don't think it is anything with the database. My IT guys think it is a corrupt database, but to me that makes little sense since the db hasn't changed and it used to work.

    Any other ideas?

    Just to give a background (this may be the root of the problem):
    Desktop computer (and this particular db) is used solely by me, but has a network login
    Attached to large network with multiple mapped drives
    the db is housed on an iomega because of confidential information - it is locked up every night
    Has office standard XP (2002), but also has access 2000 and access '97 loaded
    SP3 from Microsoft hasn't been loaded correctly (getting an error on that)
    DB with no changes to structure/format worked perfectly 2 days ago.

    Thanks again!

  4. #4
    Join Date
    Apr 2002
    Location
    Portugal
    Posts
    146
    Hi,

    This problem happens to me, it is a bug in Access 2000 and 2002.
    The problem occurs, because you may have import or made a copy of a form from another database into the one you are working. Note that in this versions of Access the VB is diferent that in Access97, you can work diferent modules at the same time, and they are connected. So if you copy or import an object and after that, don't compile the modules, you get that error.

    To resolve the problem, do the following:

    1. - Create a new database,
    2. - Import all the objects from the corrupt database,
    3. - Open a module, and compile the aplication.

    Now open a form and you will see, that the problem is solved.

Posting Permissions

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