A table was opened and a filter used on the table and upon exiting Access
asked if the design change was to be saved and mistakingly I hit yes. Now
when I open the table it is always limited to the filter. How can I
remove/undo this? Thanks.
Ofer Cohen - 16 Jul 2007 16:02 GMT
Open the table in design view
From the menu select View > properties > There remove the filter from the
Filter property

Signature
Good Luck
BS"D
> A table was opened and a filter used on the table and upon exiting Access
> asked if the design change was to be saved and mistakingly I hit yes. Now
> when I open the table it is always limited to the filter. How can I
> remove/undo this? Thanks.