Results 1 to 5 of 5

Thread: Deleting remote open file (*.mdb)

  1. #1
    Join Date
    Jul 2009
    Posts
    12

    Deleting remote open file (*.mdb)

    Hello,

    I am using an application programmed in Access (creating schedules). Other people in the network have a kind of "emulator" to view these schedules, and I make regular updates to files.

    My problem:
    During a consultation with a remote person, a .Mdb opens. And for me to update files, I have to erase everything (in a folder) and copy my own files. But I find myself with the message (Windows) as what the file is already open and I can not erase. FYI, I am not a network administrator.

    - Environment: Windows 2000 Professional
    - Mdb files created in Access 97

    My expectation: Is there a way or solution for:
    - Or force them to remotely delete this file?
    - Either disconnect remote (but I can not know the number of PCs that opened the file) all persons who have opened the application before I upgrade?

    My only solution now is to call my director (when I have to!) So that the user disconnects.

    Is there not a possibility to disconnect the target directory before copying the files using net.exe?

    Thank you for your possible answers.

  2. #2
    Join Date
    Nov 2008
    Posts
    173

    Re: Deleting remote open file (*.mdb)

    Hello,

    If an Access file is opened, it must be near a '.Ldb'. This file is readable with notepad and contains the names of machines that open the MDB file.

    If you mastering the code, you can put in place a system which periodically scans the directory looking for a file. And if this file is present, it automatically closes the database.

  3. #3
    Join Date
    Jul 2009
    Posts
    12

    Re: Deleting remote open file (*.mdb)

    Hello,

    Yes indeed, automatically .Ldb file is created at the beginning and I can actually find the pc just to connect. But I do not have sufficient rights to deny access to the remote directory.

    Any more suggestions?

  4. #4
    Join Date
    Jul 2009
    Posts
    12

    Re: Deleting remote open file (*.mdb)

    But I may have found the solution. I found a utility (Rmtshare.exe) that works with switches from net share but with the difference in contrast to the latter, change the permissions on the network. I'll try that and see if the application in question can be launched from a PC that is not an administrator of the system, it would take the baton of my order. I will post if this issue is resolved.

  5. #5
    Join Date
    Dec 2008
    Posts
    239

    Re: Deleting remote open file (*.mdb)

    Try to rename. You should also consider how and WScript.Network obtain the network user names of people who have the database open. Also, create a blank database with a single form which states "This database is currently unavailable "and a button to exit the database. Instead of giving everyone access to the database, hiding in a subfolder and give them a shortcut instead.

Similar Threads

  1. Replies: 4
    Last Post: 14-04-2015, 01:53 PM
  2. Replies: 4
    Last Post: 19-02-2011, 09:32 AM
  3. Error Deleting file or folder
    By Deabelos in forum Windows XP Support
    Replies: 5
    Last Post: 20-11-2010, 06:07 PM
  4. deleting file from Vista not working
    By Ashton5 in forum Windows Software
    Replies: 4
    Last Post: 11-04-2009, 05:54 PM
  5. Deleting a file in system 32...
    By Gaffigana in forum Vista Help
    Replies: 2
    Last Post: 03-03-2007, 05:47 PM

Posting Permissions

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