Ron, et al I experimented with a couple of methods. The one that Ron suggested was the best (in my opinion.) I started with a 67 Meg file and now it is an 8.5 Meg file! It was fast and no problems. This should solve my problem for some time! It would be nice to build this into DXbase 2004, it would help those of us who are "tech challenged".
Bill, W5VX -----Original Message----- From: Ron Stordahl [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 9:15 AM To: Bill Parry; [email protected] Subject: Re: [DXBase] My .mdb is getting big I use http://www.gracemere.com/AccessMaintainer/downloadnow.asp It's free and it installs such that when you right click on the file name from Windows Explorer in addition to the usual things in the drop down list you will also get an option to compact the data base. You will be amazed how much smaller your data base will be. You said its 67 MB now, let us know what happens. Ron N5IN ----- Original Message ----- From: "Bill Parry" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 27, 2003 8:20 AM Subject: [DXBase] My .mdb is getting big > I keep my DXBase 2003 on two computers in my shack. The one I log from is > old and slow, so when I do QSLs and maintenance I always do it on my other > computer. I have a Zip drive on both computers and I copy the files from one > computer and put them on the other. This has the advantage of keeping me > backed up in case my old computer dies on me. > > Over the last year my log file has ballooned to 67 Megs and I know a lot of > guys must have much larger log files than this. Soon I won't be able to copy > my files onto a 100meg zip anymore, not to mention it will take a long time. > I read earlier that you can use Access to "compact" these files but I wasn't > able to get it to work out for me. > > While we are asking for additions to DXBase 2003 for the upcoming version, I > really wish that something could be built in to allow us to make this file a > little smaller. > > Bill, W5VX > > _______________________________________________ > DXBase Reflector - Please visit us on the web at www.dxbase.com > - - - - - - - - - - - - - - - - - - - - - - - > To UNSUBSCRIBE please visit: > http://mailman.qth.net/mailman/listinfo/dxbase >
