Home : Products : Aspen : New user defined fields missing from tables
Q10210 - FAQ: New user defined fields missing from tables

I Added fields to a table and they keep disappearing.

 

Information in this Article applies to:

  • Aspen version 7.x
  • Aspen version 6.x
  • Aspen version 5.x
  • Aspen version 4.x
  • Aspen version 3.5
  • Conifer32 version 4.0

You are probably trying to modify a linked table.  When you open program.mdb and click on the Tables tab you will see numerous tables.  Some tables have black arrows next to them.  The black arrows indicate that these tables don't physically reside in program.mdb in actuallity they reside in working.mdb.  To modify a table that is linked you will need to close program.mdb and open working.mdb.  You will notice when you open working.mdb that none of the tables have these black arrows next to them.  This indicates that the database "owns" that table and you can now add your fields to the table structure.  When go back and open program.mdb and look at the table you modified in working.mdb you will see that the field is now present.

 

Keep in mind that you can change data in a linked table but you cannot change the structure of a linked table.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 11/17/2005 2:44 PM.
Last Modified on 1/31/2008 10:39 AM.
Last Modified by No Author Name Available!.
Skill Level: Novice.
Article has been viewed 5086 times.
Rated 6 out of 10 based on 5 votes.
Print Article
Email Article