How compress and repair mdb?

Hello NG,

I have written a programme, that inserts new data into a database table. But
the size of the mdb increases. I can change the size by calling "Compress
and Repair" from the menu. How can I do this automatically in my programme
(source code)? Is there a query that can do it?

Thanks for help,
Guido


.

Relevant Pages

  • Re: A strange problem
    ... the database side. ... David Clifford wrote: ... My programme runs normally until a function is called. ... In my programme, all recordsets are disconnected recordsets, all ...
    (microsoft.public.vb.general.discussion)
  • Re: How compress and repair mdb?
    ... >I have written a programme, that inserts new data into a database table. ... >the size of the mdb increases. ... you can not Compact the running database. ...
    (microsoft.public.access.queries)
  • Semiconductor catalogue
    ... I wrote a semiconductor catalogue programme. ... There're console and graphics version. ... help to develop programme and database. ...
    (sci.electronics.components)
  • Re: Bow Dialogues: BBC response
    ... If the database doesn't contain this information, ... Might be worth the Freedom of Information Act angle, as FoI requests ... to technically review the programme before it was broadcast. ...
    (uk.tech.broadcast)
  • Re: Saving data quickly to a database
    ... Bulk Insert using Xml is my favorite tool of choice. ... I plan to import some data from an old DOS-based programme. ... The data will be imported into a database table. ... Do you have any general tips on how store the data to a database (SQL ...
    (microsoft.public.dotnet.languages.csharp)