I am creating a database from vb.net code and while creating itself i want to set the compact property of database so the next time i need not open it and compact it or run a separate code to compact it.
I browsed the net but i got source code which will compact the database but not set its compact property(the one we find in Tools>option>general>Compact & repair database).it is not a long term solution
Is this possible.