?
Solved

Goldmine over BDE - mailbox too large - how to pare down?

Posted on 2006-11-13
5
Medium Priority
?
614 Views
Last Modified: 2012-06-27
Got a client running Goldmine on the included BDE database engine.  Their mailbox database memo file is nearly 2GB and needs to be pared down.  What tool can I use to get into that database (including the monster memo file) and archive off about half of the records?

I tried using FoxPro, MS Access with an ODBC connector - nothing seems to work.  Any tips?

Thanks in advance!
0
Comment
Question by:ejbman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 31

Expert Comment

by:moorhouselondon
ID: 17931970
There should be some *.?DX files in the data directory.  What extension are these files?  If MDX then try Dbase4.
0
 
LVL 1

Author Comment

by:ejbman
ID: 17945205
moorhouselondon,

I try that through Access and even though a massive .fpt files is there, it give me "Cannot locate the requested Xbase memo file."

any other thoughts?
0
 
LVL 31

Accepted Solution

by:
moorhouselondon earned 2000 total points
ID: 17948558
.fpt is a FoxPro file.

You need to investigate recovery tools.  The only issue you may have is if Goldmine have changed the Memo Header structure so that standard tools such as these will fail (it's not that the wouldn't want you to recover your data, but by recovering data in an unauthorized way may screw up something fundamental in GoldMine - for instance, endangering Referential Integrity).

http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools~VFP

Take backup copies first!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifiā€¦
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
Viewers will learn how to use the Hootsuite Dashboard.

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