how to compact database file?
-
My database file (MDB) is larger day by day I want its size is small again but I don't know how to fix it :eek: it look like COMPACT DATABASE of Access Counld you help me :confused: thanks
-
My database file (MDB) is larger day by day I want its size is small again but I don't know how to fix it :eek: it look like COMPACT DATABASE of Access Counld you help me :confused: thanks
What program are you using? Access 2002 has Compact and repair.. Other programs use Dump and Load... jhaga CodeProject House, Paul Watson wrote: ...and the roar of John Simmons own personal Nascar in the garage. Meg flitting about taking photos.Chris having an heated arguement with Colin Davies and .S.Rod. over egian values. Nish manically typing *censur*. Duncan racing around after his pet *c.* Michael Martin and Bryce loudly yelling *c.* C.G. having a fit as Roger Wright loads up *c.* . Anna waving her *c.* and Deb scoffing chocolates in the corner. ...Good heavens!
-
What program are you using? Access 2002 has Compact and repair.. Other programs use Dump and Load... jhaga CodeProject House, Paul Watson wrote: ...and the roar of John Simmons own personal Nascar in the garage. Meg flitting about taking photos.Chris having an heated arguement with Colin Davies and .S.Rod. over egian values. Nish manically typing *censur*. Duncan racing around after his pet *c.* Michael Martin and Bryce loudly yelling *c.* C.G. having a fit as Roger Wright loads up *c.* . Anna waving her *c.* and Deb scoffing chocolates in the corner. ...Good heavens!
I mean: is there a SQL statement to COMPACT DATABASE ? "Dump and Load" >>>> could you show me more detail about it? thanks
-
I mean: is there a SQL statement to COMPACT DATABASE ? "Dump and Load" >>>> could you show me more detail about it? thanks
There is COMPACT TABLE statement but you can not use it in Access as far as I know. Try VB/VBS/ASP/ADO like this: http://www.pstruh.cz/tips/detpg_CompactMDB.htm[^] or C++ like this: Visual C++: Compacting an Access Database via ADO Besides #import, the Msado15.dll (MDAC2.1), add the following #import statement to generate the wrapper classes for JRO to your .cpp classes (alternatively, you can generate the wrapper classes more efficiently by using the no_implementation and implementation_only attributes of the #import pre-processor statement):#import "C:\PROGRAM FILES\COMMON FILES\System\ado\MSJRO.DLL" no_namespace Add the following (specifying your own source and destination database paths) to the .cpp file where you want to compact the database:... try { IJetEnginePtr jet(__uuidof(JetEngine)); jet->CompactDatabase( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\nwind2.mdb", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\abbc.mdb;" \ "Jet OLEDB:Engine Type=4"); } catch(_com_error &e) { ::MessageBox(NULL, (LPCTSTR)e.Description( ), "", MB_OK) ; } jhaga CodeProject House, Paul Watson wrote: ...and the roar of John Simmons own personal Nascar in the garage. Meg flitting about taking photos.Chris having an heated arguement with Colin Davies and .S.Rod. over egian values. Nish manically typing *censur*. Duncan racing around after his pet *c.* Michael Martin and Bryce loudly yelling *c.* C.G. having a fit as Roger Wright loads up *c.* . Anna waving her *c.* and Deb scoffing chocolates in the corner. ...Good heavens!
-
My database file (MDB) is larger day by day I want its size is small again but I don't know how to fix it :eek: it look like COMPACT DATABASE of Access Counld you help me :confused: thanks
Given that you are using an Access database, you could use
CDaoWorkspace::CompactDatabase(). -
Given that you are using an Access database, you could use
CDaoWorkspace::CompactDatabase().thank but I dont use MFC :omg: I use non-MFC and I dont know how to use DAO in non-MFC form