Thank you, Liveson. My problem is this. I inherited an Access database at work which was created by someone who doesn't really have a DB mentality, for instance, there are about 10 different events that we are tracking, all involving the same people, so she made a different table for every event every time it occurred, typing the same info (names, addresses, etc.) over and over again. So, I have spent the past couple of years, whenever I had time, trying to consolidate all this information. My main problem is that I had previously worked with Filemaker Pro and have basically taught myself what I know of Access by trial and error.
Anyway, so now I have this table with about 210 fields and a I need to add a few, but it keeps saying that there are already 255 fields defined. So, I'm thinking that there are fields that were part of the DB in the past, but I have deleted them and that maybe those definitions are still hiding somewhere clogging up the works. Is this possible? And if so, is there someplace I can go to get rid of them? Thanks, Janet
