How about stopping users adding more records - you don't say what
software you are using, (e.g. Delphi VB, web-based) but don't have an
add facility. Its the only safe way.
No idea what your database contains, but if you have the equivalent of a
master-detail relationship, what do you want to happen if a master
record is added with, say, 12 detail records and the 11th detail record
takes you over the limit? Rollback all is my take, but this is a very
artificial limit.
Set roles for users to allow record-adding. No role granted - no
record-adding allowed.
Or, how about a bigger disk?

Alan J Davies
Aldis

On 06/06/2011 14:12, pcmilhouse wrote:
> I would like to limit the size of my firebird db. Is it possible?
>
> The system is installed in a PC with limit size for HD (for example I
> can allocate only 5 GB for Database). How can I limit the file to not
> encrease more than 5 GB?
> Obviuosly I periodically delete record in table to save space, but the
> only way I found to decrease db size is to export and import it through
> gbak. I would like to do it without disconnect my application to db?
>
> Any ideas?
>
> Thanks
>
>
> ------------------------------------------------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 10.0.1382 / Virus Database: 1511/3684 - Release Date: 06/06/11
>