access created a new field?

L

LGarcia

Hi all,
Weirdness has occurred and I don't know how it happened.
I was running a macro that exports a set of tables using saved specs. I came
across an error when exporting my master table. When I went to look at the
structure of my master table I noticed that a text field named "ID2" had
been added as the last field. I didn't create this field. When I delete this
field I get a warning that Access will be required to delete one or more
indexes. I delete the field and everything seems to be OK.
More info: This master table is part of a project specific MDB that is
copied from an empty MDB we use as a template. The ID2 field in the master
table stored in the template MDB occasionally will have this ID2 field. I
delete it from the template but after a while it mysteriously reappears. I
use code to copy and then rename the template MDB.
Has anyone had this happen before? Anyone know why this happens?
Thanks,
LGarcia
 
Top