Why dont you just empty the tables and reuse it.
----- Original Message -----
From: anhtruong52
To: [EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 12:46 PM
Subject: [AspClassicAnyQuestionIsOk] Re: How can I delete completely a mdb fife?
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
ADVERTISEMENT
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ 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/
