Click here to Skip to main content
15,925,602 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Time Display Pin
Michael Dunn20-Nov-01 16:30
sitebuilderMichael Dunn20-Nov-01 16:30 
GeneralA real challenge . . . customizing programs without the source code Pin
chris196220-Nov-01 10:14
chris196220-Nov-01 10:14 
GeneralRe: A real challenge . . . customizing programs without the source code Pin
Alvaro Mendez20-Nov-01 11:41
Alvaro Mendez20-Nov-01 11:41 
GeneralRe: A real challenge . . . customizing programs without the source code Pin
chris196220-Nov-01 17:38
chris196220-Nov-01 17:38 
GeneralRe: Load the resource by the different DLL! Pin
Masaaki Onishi20-Nov-01 16:52
Masaaki Onishi20-Nov-01 16:52 
GeneralRe: A real challenge . . . customizing programs without the source code Pin
Rassman20-Nov-01 22:26
Rassman20-Nov-01 22:26 
GeneralOT : integrating a TCL command line into an MFC Application Pin
Stephane Routelous20-Nov-01 9:40
Stephane Routelous20-Nov-01 9:40 
Generalcompacting a database on-the-fly Pin
Sean McKinnon20-Nov-01 8:58
Sean McKinnon20-Nov-01 8:58 
Hi All,

When you delete records from tables in a .MDB database file, the record space is marked as available, but is not removed from the file. So the file size grows over time.

As near as I can tell, the only way to reclaim that space is to compact the database. It would be really nice if the "available" space could be re-used by new records, but it doesn't look like this can happen. It would also be nice if you could compact just a single table in the database, but again, it looks like you have to do the whole .MDB file.

To compact a database, you must have exclusive access to it, and it must be closed (so how do you tell other applications to drop their connections to it?).

The database file must be compacted to a temporary file, and then the original deleted, and the temp file renamed.

This is a major pain when you have an application that is running ALL the time (and also when there are other apps also accessing the .MDB file).

Does anybody know of a way to reclaim the "available" space in a .MDB file, either by have the space be re-used for new records, by compacting only a table within the database, or by being able to compact the database without having to shut EVERYTHING down?

Thanks VERY much!

- Sean
GeneralRe: compacting a database on-the-fly Pin
Carlos Antollini20-Nov-01 9:52
Carlos Antollini20-Nov-01 9:52 
GeneralRe: compacting a database on-the-fly Pin
Sean McKinnon20-Nov-01 9:58
Sean McKinnon20-Nov-01 9:58 
GeneralRe: compacting a database on-the-fly Pin
Carlos Antollini20-Nov-01 10:06
Carlos Antollini20-Nov-01 10:06 
GeneralList columns question ! Pin
Hadi Rezaee20-Nov-01 8:28
Hadi Rezaee20-Nov-01 8:28 
GeneralRe: List columns question ! Pin
Joaquín M López Muñoz20-Nov-01 8:44
Joaquín M López Muñoz20-Nov-01 8:44 
GeneralRe: List columns question ! Pin
Hadi Rezaee20-Nov-01 14:59
Hadi Rezaee20-Nov-01 14:59 
GeneralClose Active Document Pin
Troy20-Nov-01 8:28
Troy20-Nov-01 8:28 
GeneralRe: Close Active Document Pin
Bill Wilson20-Nov-01 13:06
Bill Wilson20-Nov-01 13:06 
GeneralRe: Close Active Document Pin
Troy20-Nov-01 19:48
Troy20-Nov-01 19:48 
Generalproblem with CTreeCtrl::GetSelectedItem() Pin
Vu Nguyen20-Nov-01 8:21
Vu Nguyen20-Nov-01 8:21 
GeneralRe: problem with CTreeCtrl::GetSelectedItem() Pin
Mukkie21-Nov-01 7:15
Mukkie21-Nov-01 7:15 
GeneralRe: problem with CTreeCtrl::GetSelectedItem() Pin
Vu Nguyen21-Nov-01 9:07
Vu Nguyen21-Nov-01 9:07 
GeneralCompiler Errors! AHHHH! Pin
20-Nov-01 7:21
suss20-Nov-01 7:21 
GeneralRe: Compiler Errors! AHHHH! Pin
Joaquín M López Muñoz20-Nov-01 7:28
Joaquín M López Muñoz20-Nov-01 7:28 
GeneralRe: Compiler Errors! AHHHH! Pin
Alvaro Mendez20-Nov-01 7:49
Alvaro Mendez20-Nov-01 7:49 
GeneralRe: Compiler Errors! AHHHH! Pin
James Bird20-Nov-01 10:00
James Bird20-Nov-01 10:00 
GeneralRe: Compiler Errors! AHHHH! Pin
Alvaro Mendez20-Nov-01 12:17
Alvaro Mendez20-Nov-01 12:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.