Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    89

    Unanswered: Big problem!! can't find module.

    If got a big problem.
    I have a Database (back end & Front end) placed on my network map.(Shared)

    If not recently made a backup. (big mistake)

    Now when i open the database with the L-shift and i can open the forms, querys, reports and the back ended tables with no problem but the modules and also the vba from the forms and reports don't work!

    When i open these i get the error: "Error accessing file. Networkconnection may have been lost."

    Is there a way to repair this or to make this work again because if got a lot of code in there and have not backed it up.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    its never EVER a mistake to take a backup......

    and...
    'Is there a way to repair this or to make this work again because if got a lot of code in there and have not backed it up.' would suggest you already know that

    as to how you recover the code......
    go back to your most recent backup and try to reinstate
    take cop[ies of the exisiting front end file and see if a compact and repair works on one copy
    see if a decompile works
    or perhaps better yet
    You receive an error message when you try to view the code in a module, compile a database, create an MDE file or execute code in Access 2000
    ...BUT only on copies NOT the orignal file

    check your code will compile

    once you are out of your current predicament that regular backups
    deploy the front end on each users local machine, deploy the back end on a server share
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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