[DXBase] .MDB File Size

2003年9月13日 09:33:38 -0400

I use Access 2000 routinely to compact my DXBase files. As others have said,
their are two things to remember when doing this:
1. ALWAYS make a backup of your .mdb file!
2. NEVER use the Access option to "Convert your database"!
Follow those two simple steps and you'll never have a problem. Also, the
warning that Access gives when you open the file, "You can't make changes to
the database objects..." simply means you can't add fields or change the
database structure. You CAN use Access 2000 to do mass changes, search &
replaces, things like that to the 'data' in the database. Just remember, be
sure you BACKUP first!
For those unfamiliar with Access, the command to compact the database can be
found under:
Tools--> Database Utilities--> Compact and Repair Database.
Hope this helps,
Jim, KK1W
-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Richard Solomon, W1KSZ
Sent: Saturday, September 13, 2003 9:22 AM
To: Joseph Glockner; [email protected]
Cc: [email protected]
Subject: RE: [DXBase] .MDB File Size
Just make sure you make a back-up copy first ....
73, Dick, W1KSZ
-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Joseph Glockner
Sent: Saturday, September 13, 2003 12:45 AM
To: [email protected]
Cc: [email protected]
Subject: Re: [DXBase] .MDB File Size
Tom,
You can "Compact" your MDB file by taking it into Acess97 program and
compacting it .. ONLY Access97 though - not Access2000 ... or, you can
use the "Access Maintainer Lite" program (that is meant for Access97
MDB files) and it will compact it automatically ...
Yes- your MDB file will "grow" -- but you can routinely "compact"
it and you will be very pleasantly surprised at how much space is
taken up by "dead areas in your MDB file" ..
The main thing here is to compact it with ONLY programs used for
Access97 ..
73 de Joe WA6AXE
[email protected] wrote:
> After importing DXB 2003 into DXB 2004 I noticed the size of my K4XG.MDB
file
> increased from 24 megs to 54 megs. I have just over 24,000 QSOs in the
file.
> Is this normal to increase this much? Thank you.
>> Tom Neill, K4XG
>>> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> The reason this message is shown is because the post was in HTML
> or had an attachment. Attachments are not allowed. To learn how
> to post in Plain-Text go to: http://www.expita.com/nomime.html ---
> _______________________________________________
> DXBase Reflector - Please visit us on the web at www.dxbase.com
> - - - - - - - - - - - - - - - - - - - - - - -
> To UNSUBSCRIBE please visit:
> http://mailman.qth.net/mailman/listinfo/dxbase
>
_______________________________________________
DXBase Reflector - Please visit us on the web at www.dxbase.com
- - - - - - - - - - - - - - - - - - - - - - -
To UNSUBSCRIBE please visit:
http://mailman.qth.net/mailman/listinfo/dxbase
_______________________________________________
DXBase Reflector - Please visit us on the web at www.dxbase.com
- - - - - - - - - - - - - - - - - - - - - - -
To UNSUBSCRIBE please visit:
http://mailman.qth.net/mailman/listinfo/dxbase