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

Posted on 2006-11-13
Medium Priority
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!
Question by:ejbman
  • 2
LVL 31

Expert Comment

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

Author Comment

ID: 17945205

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?
LVL 31

Accepted Solution

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).


Take backup copies first!

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this tutorial, we’re going to learn how to convert Youtube to mp3 for Free. We'll show you how easy it is to make an mp3 from your video clips so that you can enjoy them offline.
The narrative of smartphone revolution is incomplete without the mention of apps, for the latter is being used today for a variety of purposes. From booking hotel (or plane) tickets to ordering food to even conducting small businesses, mobiles apps …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

624 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