🚀 go-pugleaf

You can not compact MS Access database when some app is connected to it even
from MS Access. For other DBMS "compact" may be not applied. Database may be
in some files, data and log files could be different files and working with
data and log files is done with different functions. However unlike MS
Access "big" DBMS can re-use space, i.e. if you delete many rows the space
they had occupied could be used again.

You may backup, shrink database (on MS SQL Server you should be only one
user connected to database). On Interbase you may backup database when there
are many users connected but you will backup into another file and you will
continue to use existing (not compressed) file.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Steve Aletto" <steve_alettoANTI@SPAMhotmail.com> �������/�������� �
�������� ���������: news:4039f5fa$1@newsgroups.borland.com...
> Thanks Viatcheslav,
>
> > When compacting Access db it must be disconnected.
>
> Isn't there a way to do it while the db is connected and the
> application is reading from/writing to it? The problem is
> that I have an application _always_active_ that must add and
> delete records _very_often_.
>
> - How should I do under that (or similar) condition?
> - Does a different DBMS such as MySQL or SQL server have the
> same "limitation"?
>
> Thanks again,
>
> Steve.
>
>