Deleting data in a linked table is not supported by this ISAM. (Error 3617)

Hi:

I am working with an XLS file, andhave Access 2000.

When I try and clear the xlf file (so that xls can use it for additional data), I get an
error message:


"Deleting data in a linked table is not supported by this ISAM. (Error 3617)"

What do I need to do to avoid this?

Thanks

John Baker

re: Deleting data in a linked table is not supported by this ISAM. (Error 3617)

You can't do that.....

You will have to work out a different method: Perhaps delete
the file and create a new empty file, or perhaps use Excel
Automation to clear or delete the data, or perhaps just
update all of the data to zero/blank.

(david)

"John Baker" <Baker.JH@Verizon.net> wrote in message
news:d7ag809kaikctofonerq9ghbkdl8lo9e0j@4ax.com...[color=blue]
> Hi:
>
> I am working with an XLS file, andhave Access 2000.
>
> When I try and clear the xlf file (so that xls can use it for additional[/color]
data), I get an[color=blue]
> error message:
>
>
> "Deleting data in a linked table is not supported by this ISAM. (Error[/color]
3617)"[color=blue]
>
> What do I need to do to avoid this?
>
> Thanks
>
> John Baker[/color]