<div>
Thanks ryancys<br />
Your answer works a treat.<br />
<br />
I tried the free code but it did not work for some reason.<br />
<br />
arquette2
</div>


Thanks ryancys
Your answer works a treat.

I tried the free code but it did not work for some reason.

arquette2

<div>
Hi arguette2, firstly glad can help you. and please pay tribute to TimCottee, one of the Expert in the Top 15 list. I get this code from what he posted earlier.<br />
<br />
Then as compacting database, you can use DAO to do it so, find more about compact database in those VB website that may help. : )
</div>


Hi arguette2, firstly glad can help you. and please pay tribute to TimCottee, one of the Expert in the Top 15 list. I get this code from what he posted earlier.

Then as compacting database, you can use DAO to do it so, find more about compact database in those VB website that may help. : )

<div>
<div class="content wysiwyg-content">
I am using access tables as work tables in VB6.<br />
I am deleting records. Each time I run the program the DB gets larger by about 2MB. I do not want to have to have Access on the users machine so how do I compact the database so as to keep it from getting too big. I have used Access tables with VB6 apps before without having Access on the user machine but I did not notice this increase in the DB size.<br />
<br />
I have tried dropping tables and then creating them when needed but this makes no difference.<br />
<br />
Have the experts any ideas<br />
<br />
Thanks
</div>
</div>


I am using access tables as work tables in VB6.
I am deleting records. Each time I run the program the DB gets larger by about 2MB. I do not want to have to have Access on the users machine so how do I compact the database so as to keep it from getting too big. I have used Access tables with VB6 apps before without having Access on the user machine but I did not notice this increase in the DB size.

I have tried dropping tables and then creating them when needed but this makes no difference.

Have the experts any ideas

Thanks

Compacting work tables in vb

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.