Removing isolated open file (*.mdb)

HernandezOrtiz · 02-06-2010, 12:25 PM

I am using Access. Other people in network have type of "emulator" to show schedules, and make regular updates to files. Problem is I want to delete all and copy own files. But message appears as what the file is already open and I cannot erase.

MartinWilson · 02-06-2010, 12:26 PM

1) If an Access file is opened then it is readable with notepad and has names of machines that open MDB file. If you mastering code, put system that scans directory looking for file. If it found that it is present then it automatically closes database.

HernandezOrtiz · 02-06-2010, 12:27 PM

2) Yes, automatically .Ldb file is made at starting and I found when PC just to connect. But I do not have rights to disallow access to remote directory. Any more suggestions?

MartinWilson · 02-06-2010, 12:28 PM

3) Just attempt to rename it and you must think how and WScript.network get network user names of people who have databases open. Make blank database with one form "This database is currently unavailable "and button to close database. Giving everybody access to database, hide it in subfolder and give shortcut to use them.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Removing File in Windows Installer	PerryCollins	Operating System	0	01-27-2010 11:57 AM
Open a ZIP (zip) file?	aldrin	Software Jargons	1	12-16-2009 03:14 PM
How do I open a .bin file?	Javante Illingworth	Linux/Free BSD	0	11-27-2009 11:36 AM
To open file with Vim	Diego Tylor	Everything Else	0	07-01-2009 12:19 PM
Removing .PDF file type association	xinalk	Technologies	0	08-23-2008 12:58 PM