We help IT Professionals succeed at work.

Compact Access Database

karnelia
karnelia asked
on
Hi Lister.

Anyone know any standard component from Delphi or third-party tools that can be used to compact access database, like DBEngine in Visual Basic ?
I need it because deletion on access database, will not make the database size smaller, so compact database is the only way to shrink it.
It's easy in Visual Basic, but I couldn't think of something like that in Delphi.

TIA,
Karnel
Comment
Watch Question

If you are using ADO, then this is a link with an article which shows you how to compact a Access-DB :

http://delphi.about.com/library/weekly/aa091801a.htm

Author

Commented:
Thanks Mike.
Thanks a lot.

Author

Commented:
Thanks Wimmeyvaert.

I'm sorry I've accepted Mike's answer before I read yours.
You're both very helpful, thank you both.

Regards,

Karnel
No problem,

My suggestion only works when using ADO.
I suppose Mike's suggestion works only when using BDE, and only for Access97-DB, not Access2000.

Best regards,
The Mayor.

Author

Commented:
I see.
Thanks again.

Karnel

Commented:
Glad to be of service.

GL
Mike

Explore More ContentExplore courses, solutions, and other research materials related to this topic.