Go Back   TechArena Community > Technology > Networking & Security
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Deleting remote open file (*.mdb)

Networking & Security


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-02-2010
Members
 
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.

Reply With Quote
  #2  
Old 05-02-2010
Member
 
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.
Reply With Quote
  #3  
Old 05-02-2010
Members
 
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?
Reply With Quote
  #4  
Old 05-02-2010
Members
 
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.
Reply With Quote
  #5  
Old 05-02-2010
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Technology > Networking & Security
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Deleting remote open file (*.mdb)"
Thread Thread Starter Forum Replies Last Post
Error Deleting File or Folder. Cannot delete (FILE): Access denied rasena MediaCenter 3 21-03-2012 09:10 AM
After deleting the Windows Live folder Internet Explorer 8 64-bit will open but 32-bit not Priscilia Technology & Internet 4 19-02-2011 09:32 AM
Error Deleting file or folder Deabelos Windows XP Support 5 20-11-2010 06:07 PM
deleting file from Vista not working Ashton5 Windows Software 4 11-04-2009 05:54 PM
Deleting a file in system 32... Gaffigana Vista Help 2 03-03-2007 05:47 PM


All times are GMT +5.5. The time now is 07:57 AM.