I have a VBA script that runs HyperSizer thousands of times. After 20,000 or so calculations, the database grows too large, and no more calculations can be performed. I can fix this by manually compacting the database, however I'd like to do this using the API if possible. I'm running into problems closing the database, though.
I am guessing that in order to compact the database I have open, I must first close it. When I make the call:
HyperSizer.Application.CloseDatabase
...I get an unhandled error that reads:
"Run-time error '-2147188733 (80048003)' Unhandled Error, Application Error in Application::CloseDatabase[Function]() Line #17, Error #-2147188737, Error returning HyperSizer license"
I am using version 5.8.11 of HyperSizer. Any sage advice on how to get around this?