[Dxbase] Compact database error

[Gary AL9A]

Thanks for the reply John.  That let me know that it is possible to make the 
compact utility work under Vista.  After a bit of trial and error I finally 
got it to work!  The trick was to click on the ... button and manually point 
the utility program to the al9a.mdb file in the Virtual Store path.  Once I 
did that and let it run it completed without error and reduced my file size 
by half.

Apparently there are different things that need to be done path name wise 
under Vista depending on the utility being used.  For instance, under File 
Backup the path names for the files to be backed up are at C:\Program 
Files\Scientific Solutions\DXbase 2006, but the files that are actually 
backed up are those that reside in the Virtual Store path at 
C:\Users\AL9A\AppData\Local\VirtualStore\Program Files\Scientific 
Solutions\DXbase 2006.

As noted above, under the Database utility to compact a file the path must 
be set to C:\Users\AL9A\AppData\Local\VirtualStore\Program Files\Scientific 
Solutions\DXbase 2006 or else it doesn't work.

I've also had trouble with the WriteLog country file update process.  The 
wl_cty.dat file must be downloaded into the WriteLog programs folder and 
their conversion utility path pointed to that folder.  But, when the utility 
completes running the output binary file, wl_cty.bin, ends up in the Virtual 
Store location.  I know Microsoft must think they know what the heck they're 
doing, but it remains a mystery to me!

73,
Gary AL9A


----- Original Message ----- 
From: "John Pelham" <john at radiophile.com>
To: "DXBase Reflector" <dxbase at mailman.qth.net>
Sent: April 11, 2008 5:55 PM
Subject: Re: [Dxbase] Compact database error


> Gary,
>
> I've been running DXbase under Vista (32 bit) for about a year now.  I 
> have not seen this problem.  Your e-mail reminded me I hadn't compacted my 
> database in a while, so I just did it again now and it completed without 
> error.
>
> 73,
> W1JA
>
> Gary wrote:
>> So, I made a database backup, and then tried to use the DXB Utility 
>> program to compact my al9a.mdb file.  I got the following two messages 
>> from the dxbutility program:
>>
>> 'Database already exists.'  (Well yes, I'm trying to compact it!)  When I 
>> click on OK, the second message appears.
>> 'Access to an unnamed file was denied.'
>>
>> Upon checking the Virtual Store path I found that my al9a.mdb file had 
>> been renamed to cutil.mdb.  When I started DXB the al9a.mdb file that 
>> opened was missing 600+ QSO's!  The mdb file that was being used was an 
>> older version that resided in C:\Program Files\Scientific 
>> Solutions\DXbase 2006\AL9A.mdb. The newest file was not found, having 
>> been renamed cutil.mdb.  I shut down DXB went to the Virtual Store file 
>> and renamed cutil.mdb back to al9a.mdb and restarted DXB.  The proper 
>> file opened with the missing QSO's once again in the database.
>>
>> Obviously, something is amiss in the DXB Utility for Database maintenance 
>> when running under Vista.  I am concerned not only that I cannot compact 
>> the database, but should the need arise, I may not be able to repair the 
>> database either.  Any one else running Vista ever see this?  Any ideas on 
>> a fix?
>
>
> ______________________________________________________________
> 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