Re: 'Blob' problem.Thanks.

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/21/04 

Date: Fri, 20 Feb 2004 19:59:52 -0600

>Sorry. My Programs Test On Dbase For Windows, ADO And Dao.
>I Don't How To Reduce The Database File Size( When Delete The
>Record, Database File Does't Decrease The Size )

Well you can do it with the BDE API using the
function DbiPackTable (hDb: hDBIDb; hCursor: hDBICur; pszTableName: PChar;
pszDriverType: PChar; bRegenIdxs: Bool): DBIResult stdcall;

I don't know of any way to do a compact of a dbase table with ADO or DAO.
You could create a new table and copy the records in your current table to it
then delete the old and rename the new. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Entourage Database
    ... When you delete your messages from the "Deleted Items" folder, ... not see a corresponding decrease in size of the database file. ...
    (microsoft.public.mac.office.entourage)
  • Re: Database size
    ... will not actually be reflected in the database file but Exchange will ... We have Exchange 2003/SP2. ... file actually shows a decrease of 200MB. ... (online defrag/maintenance, after it runs). ...
    (microsoft.public.exchange.admin)