BKAPHPOL just met a magic limit of 2 gigs and automatically extended itself with two files BKAPHPOL.^01 and BKAPHPOL.^02.
 
Now Dba quits out of Inventory inguiries (the window flashes open then closes).  I can still see the data through the Pervasive.SQL data manager, but nothing in DBA which accesses that file works.
 
Any ideas?
 
Thanks in advance.
 
Bob

Thanks,  But I have no SM-J-R,  it stops at SM-J-Q.

It stops at Q when you are logged in as ADMIN? How old is your update?

By the long silence,I am guessing that is not a good date  
 

I am trying the rebuilding, but it doesn't look good.  
 
It says the output file exceeds the available disk space, yet I have 93 gigs available.
 
How bout I take a file before it got extended and delete a bunch of records?  Any major risk there?

When I purge, the file actually gets bigger and pervasive split it again.  haha  can't win.
 
So the rebuild index doesn't work on the split file.
 
I am doing it again, but will examine the data and delete voided records manually.  
 
See you in November  
 
If anyone has any other suggestions I am always open.
---------------------------------
 
 
OK.  I am using a 2-day old file pair that haven't been split.
I am first reindexing, which appears to be working.  This should hopefully  reduce the size of the file.
Then I will purge and re index again.  
 
If this doesn't work... Lynn just called me from IS Tech Support.  What a pleasant surprise!  And gave another suggestion that I will try.
 
------------------------------------
This didn't work either. Re indexing also made the file larger.  After it counted down on the records it went negative .