Delete a linked file

[Roland Mayr - Chipware]

Hello NG,

maybe someone can help me. I would like to delete a txt file which is linked
to an MsAccess table. I deleted the linked table but I am still not able to
delete the external txt file. Only when I exit MsAccess it seems possible to
delete the file.

Thanks in advance.
Rolly

[Arno R]

Rolly,
The file seems to be locked. I think you need to investigate the cause of this.
Have you opened a recordset based on this file?
If so, Did you also close this recordset?
Did you open the file another way?

--
Hope this helps
Arno R
"Roland Mayr - Chipware" <in***********@tin.it> schreef in bericht
news:bp**********@newsreader.mailgate.org...

Hello NG,

maybe someone can help me. I would like to delete a txt file which is linked
to an MsAccess table. I deleted the linked table but I am still not able to
delete the external txt file. Only when I exit MsAccess it seems possible to
delete the file.

Thanks in advance.
Rolly

[David Mitchell]

Look in help file for "Kill statement"

David

"Roland Mayr - Chipware" <in***********@tin.it> wrote in message news:<bp**********@newsreader.mailgate.org>...

Hello NG,

maybe someone can help me. I would like to delete a txt file which is linked
to an MsAccess table. I deleted the linked table but I am still not able to
delete the external txt file. Only when I exit MsAccess it seems possible to
delete the file.

Thanks in advance.
Rolly