Solved

Tidying up DB's

Posted on 2003-11-20
7
181 Views
Last Modified: 2013-12-18
A simple one undoubtedly but i cant seem to ask the correct questions in help :)

A number of forms and hence fields have been deleted from various Databases, but they still show up as options to display in a view column.

How do i "tidy up" so that basically when a field is removed from the databse it is no longer an option  for display on a view column.

Example if i create a new view and select a column, attempt to Display a field, i get the option of

"untitled" "untitled2" etc as well as about 50 fields that were on forms that no longer exist.

Cheers

T
0
Comment
Question by:Tweedy
7 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
Basically: Compact your database, and remove fields from documents with older names
0
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
Or the other way round ;-) cleanup older documents and compact the database.
There have been numerous problems with fieldnames that no longer exist, all reported in several fora about Notes. They seem to have solved this issue in R6...
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 50 total points
Comment Utility
Try this

1. Create full text index (In database properties)
2. After index is created, delete it (In database properties)
3. Now compact the database
4. The obsolete fields should not be visible now

~Hemanth
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
Multiple suggestions have also been made into the direction of full-text index creation and removal. My template does not have an FTI, and compacts as it is supposed to. I absolutely fail to see the connection between FTI and fieldnames, hence I have only one word for it: Balderdash!
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
Hi sjef_bosman,
> I absolutely fail to see the connection between FTI and fieldnames, hence I
> have only one word for it: Balderdash!

I have read Sjef's comment, and I have only one word for it: Accurate!

Best regards,
qwaletee
0
 

Author Comment

by:Tweedy
Comment Utility
Thanks people, thought it would be an easy one :)
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
Sjef,

You deserved poins on this one.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now