|
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!
|
|
|
|
|
Given that you are using an Access database, you could use CDaoWorkspace::CompactDatabase().
|
|
|
|
|
thank but I dont use MFC 
I use non-MFC and I dont know how to use DAO in non-MFC form
|
|
|
|
|
I've got to make a CStatic dlgItem changing its background color as I want.
How can I do that?
|
|
|
|
|
|
|
hey,
i wrote a program that recieves video from a webcam, priviews
it and also captures it (compressed) to disk, at the same time.
now i need to be able to send the video that's being recieved,
through LAN to clients, which will also be able to priview and
capture it. my questions are:
1) is it possible (to send to multiple clients assuming that it's
not a 1GB network)?
2) is it done using a directshow filter (file async?!?!) or do i
have to implement it myself using winsock?
3) should i send the priview pin or what i compressed to file
to save bandwidth?
4) should i use directplay, RTC?
5) any source samples about this out there, that can get me
started in the right direction?
any help is very much appriciated
|
|
|
|
|
I recently bought a Psion Revo and i absolutely love it. But i want to start programming for it, but everywhere it says i need the Symbian v5 SDK but i cant find it ANYWHERE for download. Does anyone still have it or know a place where i can download it??? Please let me know.
Thanks
Kuniva
--------------------------------------------
|
|
|
|
|
How does one make another function the actual entry point into a Win32 app?
I've seen it on Codewarrior on the Macintosh that you specify what function is your entry point..
How do you do it in VC 6?
|
|
|
|
|
Select Project/Settings, go to the Link tab, select Category: Output and there you should see the "Entry-point symbol" editbox. From there you can change the entry-point of your application, which when left empty defaults to "WinMain" for win32 applications and "main" for console applications.
|
|
|
|
|
Yes, you can do that. But just out of curiosity, would it be a standard program then? I mean, doesn't the standard specify that main() should be the starting point?
In fact, Turbo C++  has a pragma option called startup that will let you start from another function, but after that, main() will be called.
Vikram.
-----------------------------
My site due for a massive update
1. Don't ask unnecessary questions. You know what I mean?
2. Avoid redundancy at all costs.
3. Avoid redundancy at all costs.
"Do not give redundant error messages again and again." - A classmate of mine, while giving a class talk on error detection in compiler design.
|
|
|
|
|
I don't see any use in changing the entry point neither, except wWinMain and wmain of course. Anyway it's just a function and called only once (as long as you're not recursing  in main) I guess people have different tastes and different ways to obfuscate their code. You never know 
|
|
|
|
|
I have no idea how to save and load the data in my List Control. Can somebody help me please!
|
|
|
|
|
Post an example of a row in the list control.
Kuphryn
|
|
|
|
|
I have a text/rich text box on a dialog. Vertical scroll is enabled for this text box. I write text on the text box. Ofcourse some text may be hidden that we can see after scrolling up or down.
Now i want everything written in the text box to be represented by a CBitmap object. How can i do so ????
Actually i want the contents of text box to be stored in a bmp file. I know how to store CBitmap contents in a BMP file, but i don't know how to first represent the text box contents in CBitmap object (as it is).
Thanks
|
|
|
|
|
you can redirect a RichText control's output using the DrawBand and FormatRange calls. i don't have any code handy to share, but it really only takes a few lines to do this. try googling on those function calls.
-c
|
|
|
|
|
You can also create a memory DC, send the control a WM_PAINT message with the handle of that DC, and extract the BMP from the DC.
|
|
|
|
|
When you right click on ANY files,you will see popup menu with SEND TO option,which you can send files to Floppy disk,Zip compressed File,My document and..... . How can I add an option to it,I think I should do it with registery.
Also how I can add menu to popup menu of specific extention,,I mean when I right click a specific extention in win explorer,it show up with additional action ,something like "Enqueue in winamp" for mp3 file.
Thanks
Mazy
No sig. available now.
|
|
|
|
|
|
Yes,I found your articles. 
Mazy
No sig. available now.
|
|
|
|
|
hello
i had add a ressource at my menu it's Slider and the name that give to it it's IDC_SLIDER1.
i want to have the position of the slider with GetPos( );
must i use IDC_SLIDER1 or what to have the position and initialise the range and position?
|
|
|
|
|
If you don't want to use DDX you could add a pointer to a CSliderCtrl called m_wndSlider and then use the code below
int initfunc()
{
m_wndSlider= ((CSliderCtrl*)GetDlgItem(IDC_SLIDER1));
m_wndSlider->SetRange(0,100);
m_wndSlider->SetPos(0);
return 0;
}
int getSliderValue()
{
return m_wndSlider.GetPos();
}
KMaz
|
|
|
|
|
i import a bitmap in Resources then get it's ID,but how can i retrive his handle .
i tried
myStatic.SetBitmap( ::LoadBitmap(NULL, MAKEINTRESOURCE(ID_of_mypic)));
but my pic doesnot appear.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
