Are recordes really deleted?

[mrdj1002]

Hi guys
Well I have a mdb Database with size of 5 mb’s there was a table in it which had taken a lot of space but when I delete it through code or through visdata or access by such SQL statement:

Delete * From Table1

All fields of the table seems to be deleted but when I check the size of the mdb file, it is exactly the same size of the file before the fields of that large table was deleted. Does anyone know what the reason is? Do the data just become invisible? But it is somewhere in the file for future restoring? And how can I remove the data completely from the database?
Thank u

[phinds]

you need to compact the db. You can do that manually, or through code. Look up "compact" in Access's on-line help.

[mrdj1002]

Originally posted by phinds
you need to compact the db. You can do that manually, or through code. Look up "compact" in Access's on-line help.

I’m using DBngine.CampactDatabase method to compact the db but one problem:
It compacts the database in a second db but I want to compact the db just where it is. Because the database must be always opened.
Is there some other way to compact the db (of course compact it in itself)?

[Cander]

no because the database must be closed to be compacted. Its a matter of file sharing violation like anything else.

Besides there is no reason to need the database to be open while being compacted.

[mrdj1002]

Originally posted by Cander
no because the database must be closed to be compacted. Its a matter of file sharing violation like anything else.

Besides there is no reason to need the database to be open while being compacted.

I can't close the db coz some other app is using it too. and that application opens the db as exclusive and this app must always be running. so once i want to run my own app i must close the second app.
open the db in my own app
then open the second app

and i can do this only once coz the app must always be running
that's why i wanted to compact the db without closing it

[techgnome]

AFAIK it can't be done. The DB MUST BE CLOSED to prevent corruption during the compacting. If it's a problem, wait until after hours when no one is using the DB.

[randem]

mrdj1002,

As all others that told you it can not be done. You need to believe it.

One must learn that one can not change the laws of physics just because they are inconvienent!!

[techgnome]

Originally posted by randem
One must learn that one can not change the laws of physics just because they are inconvienent!!

No, but you should be able to subclass it, then use a Callback Method to redefine its behavior.

[mrdj1002]

Originally posted by techgnome
No, but you should be able to subclass it, then use a Callback Method to redefine its behavior.

hey guuuys why r u hitting me
I just asked if there was any other solution. and i guess ur right i have to wait for some chance to close the db and compact it.
thank u anyway

[Shawn N]

Access database over a network?

[mrdj1002]

Originally posted by Shawn N
Access database over a network?

no it's not a network.... the case is that 2 apps are sharing one db. my app is the second app which enhances the first app capibilitis