Hi Adelle, Thanks for all detail explanations, they are very clear & reasonable! However, I did verify all of them ... not single case occuring! Here is detail what I tried:
1. This myfile.mdb is located on my Web-site "\database" location 2. Because it is a test for trying to delete a .mdb file, therefore nobody access to it! There is nothing DAO, ADO, RDO or any SQL access to it (not yet)! 3. Before & After trying to delete the myfile.mdb, I use FTP to verify it ---> it still there and without any myfile.ldb Note: Might be I missed something to mention in my case? By any chance you tried successfully once? Thanks again for help! --- In [EMAIL PROTECTED], "Adelle L. Hartley" <[EMAIL PROTECTED]> wrote: > > I have the myfile.mdb in sub-folder database, sometime I want > > to delete it but after I do the following (correct location), > > it is still there: > > You cannot delete a .mdb file while there are any users who still have an > open connection to this file. If the database is shared over a network, you > can examine the .ldb file to see which users are still connected. > > For various reasons, the .mdb file will sometimes remain locked, even when > the user has exited the application. > > If the database is being accessed via Microsoft Access, then there is not > much you can do about that except to make sure that Access has been closed > (via the Task Manager on NT/2K/XP or by rebooting on 95/98/me). > > If the database is being accessed via a Visual Basic application (using DAO, > RDO, or ADO), then you need to ensure that all open recordsets from that > database have been closed, and that all connections to that database have > been closed. > > Adelle. ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
