Hi Ed,
You could compact you database from within your app:
var
dao: OLEVariant;
begin
dao := CreateOleObject('DAO.DBEngine.35');
dao.CompactDatabase('d:\yourDB.mdb', 'd:\compactDB.mdb');
end;
The OLE object must be for the installed version of DAO. e.g.
'DAO.DBEngine.36' for DAO 3.6.
(original code by Mike Shkolnik)
Hope this helps,
Dave.
Dave Murray
Delphi-En Owner
[EMAIL PROTECTED]
--- In [email protected], "Ed Horrocks" <[EMAIL PROTECTED]> wrote:
> Hi,
> I have a small app with ms access at the back end. I have a
> particular table that has a lot of activity in terms of deletions
> and insertions.
> Not all my clients :-) would monitor the growth of the database and
> take appropriate action.
>
> Is it workable/feasible/desirable to create a sparse table prefilled
> with dummy data say with 5- 6000 rows. This would have a field that
> simply acts as a flag to indicate if that row is 'empty'. I would
> simply 'reuse' the rows. Would minimize the growth
>
> Any pointer appreciated
>
> Ed.
>
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
