looking for advice...i have an access database that has one 'data' table that i would need to archive at year end is it best to zip the whole database or export the table as a text file or???<br>
<br>
also is there a way to use vb on close statement to compact the open database? or at put a button on a form that they can click to compact the dbase?<br>
<br>
thanks
<br>
also is there a way to use vb on close statement to compact the open database? or at put a button on a form that they can click to compact the dbase?<br>
<br>
thanks