Field not Visible

[cdnMoonlight]

Using MSAccess 2000 table on Win2k box.

I added a text field to an existing table and saved it.
Made changes to form to add field. There are no error msgs.

Now when I look in the table or in a query the field is not visible. The
only way I can see the field is to create a query using the * to add all
fields to it.

When attempting to add the field again I receive an error msg saying "Can't
define field more than once"

Any Ideas?

 

[Van T. Dinh]

It sounds to me that you have a split system (Back-End & Front-End).

Have you refreshed the Linked Tables in the Front-End so that the Front-End
picks up the new Table Structure?

 

[cdnMoonlight]

I do have a separate database for the front and back ends. The problem
occurs in both databases. I can not see the field in the back end table.

 

[Van T. Dinh]

1. Open the Back-End by itself. Open the Design View of the Table. Do you
see the Field added? If you don't, you probably cancelled the adding in
error or you added the Field in the wrong copy of the Back-End.

2. If you do, create a Query in the Back-End and see if you can see the
added Field?

3. Check that the Table(s) are linked from the correct Back-End, i.e. the
Back-End that you have just checked to confirm the added Field?

4. Use the Linked Table Manager to re-link the Tables. Open the linked
Table in DesignView. Do you see the added Field?

5. Create a new Query using the (re-)linked Table. Do you see the added
Field?

 

[cdnMoonlight]

Van,
I appreciate your help trying to figure this out.
1. When I open the back end table by itself i can not see the field.
However if I try and add a field by that name it says it already exists.

2. When I create a query in the back end 2 different things happen. If I
use the * to specifiy all fields in the table then the field in question is
visible. (Which is how I was able to add it to my form without errors),
However if I try to add the field itself to a query it is not visible in the
query window to add.

 

[cdnMoonlight]

I think I just had a corrupt table. I was able to import my back end into a
new database and the field shows now.

Thanks