Deleting a field from my main table (and the problematic consequences)

[Ally1205]

Hi All,

In my Access2000 db, I have a table, on which many different queries are based. Many forms are based on those queries. I want to delete some redundant fields from the table. I tried deleting one, but I found I could no longer open any of the associated queries and forms. Is there a simple way to delete table fields so that it doesn't stop me from opening associated queries and forms? (There are hundreds of them, and I have a lot of table fields that I want to delete).

Many thanks,

Al

[ItsMe]

You can programmatically redesign query objects using .QueryDefs. It would probably be easier to open you query in design view and edit the object using the query builder.