Solved

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

Posted on 2006-11-13
5
610 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 500 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Let’s list some of the technologies that enable smooth teleworking. 
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

696 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