>Hi all,
>
>I keep getting this error: "there is not enough memory to complete this operation" when I try to append a record to a particular table. This table with three fields only has records less than 3000. I have a no trouble appending records to other much larger tables of 1mil records or more.
>
>This just started happening a couple days ago on one of our clients' W2k Sp4 Server.
>
>Has anybody seen this?

- Check the sizes of both the .DBF and .FPT if applicable. PACK and/or PACK MEMO might help.
- Possibly a corrupted index?
- If you're using INSERT - SQL to add the row, check that you're not using syntax that might be generating a Cartesian product - e.g. you left out a JOIN or WHERE clause etc.