[Dxbase] DXBase 2007 - CQ-Zone numeric statistics table

Thu Sep 20 16:26:23 EDT 2012

Yep, that's the way these complex databases work. They are constantly
allocating free space within themselves with the theory being that it speeds
things up as you add more data. Guess that's why Microsoft includes the
compact feature to get rid of the extra space when not needed.
Glad all is better now.
-----Original Message-----
From: dxbase-bounces at mailman.qth.net [mailto:dxbase-bounces at mailman.qth.net]
On Behalf Of N2TK, Tony
Sent: Thursday, September 20, 2012 4:01 PM
To: 'Ron Stordahl, AE5E'; 'Dxbase'
Subject: Re: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table
Oops! 22M. It shrank from 450M to 22M
Sri
N2TK, Tony

From: Ron Stordahl, AE5E [mailto:ronn5in-dxbase12 at yahoo.com]
Sent: Thursday, September 20, 2012 3:02 PM
To: N2TK, Tony; 'Dxbase'
Subject: Re: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table

Tony

What really bothers me is you saying that your n2tk.mdb, is only 22K! We
both have roughly the same number of Q's, about 40,000, yet my AE5E.MDB when
compressed is 14,396 KB, about 500 tines as large as yours.

This is impossible. Did you mean 22 MB?

Ron, AE5E

 _____ 
From: "N2TK, Tony" <tony.kaz at verizon.net>
To: 'Jack' <lennoxj at bellsouth.net>; 'Dxbase' <dxbase at mailman.qth.net>
Sent: Thursday, September 20, 2012 1:43 PM
Subject: Re: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table
My 5 day old backup mdb works fine. I had printed out the Q's I had made in
the past five days and manually entered them after installing the older mdb
file. All seems fine.
I ran "Compact". Now the 450K file is down to 22K just like the other one. I
am amazed how much the file will compact.
Tnx agn for the help.
N2TK, tony 
-----Original Message-----
From: Jack [mailto:lennoxj at bellsouth.net] 
Sent: Thursday, September 20, 2012 12:27 PM
To: 'N2TK, Tony'; 'Dxbase'
Subject: RE: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table
If you have a "working" backup, I'd give it a shot. Sometimes folks make
the backup not realizing that the database is corrupted and so their backup
is hosed too. But, give it a shot.
Jack
-----Original Message-----
From: N2TK, Tony [mailto:tony.kaz at verizon.net]
Sent: Thursday, September 20, 2012 11:27 AM
To: 'Jack'; 'Dxbase'
Subject: RE: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table
Tnx Jack. What about using an older database? My mdb files are backed up
automatically and I keep older files. Is it worth just trying another mdb or
just doing what you have listed below?
N2TK, Tony?
-----Original Message-----
From: Jack [mailto:lennoxj at bellsouth.net]
Sent: Thursday, September 20, 2012 11:06 AM
To: 'N2TK, Tony'; 'Dxbase'
Subject: RE: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table
Tony,
Sounds like the numeric zone statistics table within your QSO database .mdb
has gotten clobbered. Check the help file error message section for
corrective steps. Essentially you'll need to create a new empty database
and then use DXB import to import from the old now corrupted database into
the new empty one. Afterwards, when starting DXbase you'll need the prompt
set to on so you can specify the new database name at program startup. Once
booted with the new database active, you can then initialize tables.
Jack
-----Original Message-----
From: dxbase-bounces at mailman.qth.net [mailto:dxbase-bounces at mailman.qth.net]
On Behalf Of N2TK, Tony
Sent: Thursday, September 20, 2012 10:49 AM
To: Dxbase
Subject: [Dxbase] DXBase 2007 - CQ-Zone numeric statistics table
All these years with zero problems till today. I ran "Initialize Tables". I
get an error for every call - "<Call> was not found in the CQ-Zone numeric
statistics table. Update reference database".
I tried the following with no luck:
- Closed DXBase (had to use Task manager) and rebooted.
- Older refdata.mdb
- DXBase utilities - ran Compact and ran Repair. Both only run a
couple seconds. My n2tk.mdb file was 450k before compacting. It is now 22K
for 37550 QSO's. Does this sound about right?
Any ideas?
Tnx
N2TK, Tony
______________________________________________________________
Dxbase mailing list
Home: http://mailman.qth.net/mailman/listinfo/dxbase
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Dxbase at mailman.qth.net
This list hosted by: http://www.qsl.net <http://www.qsl.net/> 
Please help support this email list: http://www.qsl.net/donate.html
______________________________________________________________
Dxbase mailing list
Home: http://mailman.qth.net/mailman/listinfo/dxbase
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Dxbase at mailman.qth.net
This list hosted by: http://www.qsl.net <http://www.qsl.net/> 
Please help support this email list: http://www.qsl.net/donate.html
______________________________________________________________
Dxbase mailing list
Home: http://mailman.qth.net/mailman/listinfo/dxbase
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Dxbase at mailman.qth.net
This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html