David,

I don't know the answer to your problem, but do want to comment that I think you are misinterpreting Rushmore's use of a tag on DELETED - it should have *NO* (repeat: NO) bearing on other tag which may have a FOR DELETED clause in them.

In all probability (I can't say in fact, cause I'm somewhat dated on this) Rushmore will *NOT* be used with indices which have a FOR clause of any kind.

Cheers,
Jim N

>I need to be able to open VFP free DBF tables with Access 97 for readonly queries.
>
>All of the tables that include the tag:
>INDEX ON DELETED() tag deleted
>cannot be opened by Access.
>
>The tag is necessary for Rushmore to be used, since some of the other tags include the FOR DELETED() expression.
>
>It seems like the ODBC driver should allow all tags to be ignored if the table is only being opened in readonly mode.
>
>Does anyone know of a way around this?
>
>Thanks,
>David