Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006
    Posts
    157

    Unanswered: MS Access File Handling through vba

    hey guys,

    just when I thought that I'm perfectly fine with MS Access doing file handling and management, i get shot from behind...

    I'm using ms access as a database front end to managing files on a server...

    it copies files from workstations to the server, and then renames the file as it goes through several states...

    On a single instance, or session of the MS Access application, this procedure runs smoothly

    However, when I quit the MS Access application, and run a new instance, the file somehow gets itself locked up by the previous instance of MS Access
    ... it can no longer be renamed by the same MS Access application
    and therefore everything falls apart...

    server permissions are provided in full for the shared files that are uploaded / renamed...

    it's just this event of closing the MS Access application and running it again that seems unable to handle the file



    god bless the person with the ultimate answer...
    i really with to get over this one single glitch...
    Only quitters quit!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Seeing some code might be useful.

    Once thing Access isn't particularly great at is handling it's own trash. That means you should always close objects and set them to Nothing when they are no longer needed.

    Sounds to me like a previous instance of Access is still accessing the object, locking it for exclusive access; hence the conclusion reached above.

    Hope this helps,
    George
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Seeing some code might be useful.

    Once thing Access isn't particularly great at is handling it's own trash. That means you should always close objects and set them to Nothing when they are no longer needed.

    Sounds to me like a previous instance of Access is still accessing the object, locking it for exclusive access; hence the conclusion reached above.

    Hope this helps,
    George
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Agreed with George. Sounds like the code hasn't closed a file here or there and that leaves it inaccessible.
    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

Posting Permissions

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