<div>
you can use ADO/OLE - use the CompactDatabase method on the IJetEngine interface see<br />
<br />
<br />
<a href="http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP" rel="ugc nofollow">http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP</a><br />
<br />
<a href="http://support.microsoft.com/support/kb/articles/Q230/4/96.ASP" rel="ugc nofollow">http://support.microsoft.com/support/kb/articles/Q230/4/96.ASP</a><br />
<br />
also see <br />
<br />
<a href="http://support.microsoft.com/support/kb/articles/Q294/9/66.ASP" rel="ugc nofollow">http://support.microsoft.com/support/kb/articles/Q294/9/66.ASP</a><br />
<br />
<br />
<br />
<br />

</div>


you can use ADO/OLE - use the CompactDatabase method on the IJetEngine interface see


http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP [http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP]

http://support.microsoft.com/support/kb/articles/Q230/4/96.ASP [http://support.microsoft.com/support/kb/articles/Q230/4/96.ASP]

also see

http://support.microsoft.com/support/kb/articles/Q294/9/66.ASP [http://support.microsoft.com/support/kb/articles/Q294/9/66.ASP]






<div>
Thanks,<br />
The point is taht I need to work with the ODBC connection
</div>


Thanks,
The point is taht I need to work with the ODBC connection

<div>
I was under the impression you can use Jet to access ODBC
</div>


I was under the impression you can use Jet to access ODBC

<div>
sorry but I'm not sure I understand.<br />
<br />
I would like to know if I can execute the command to comapct and repair the mdb file whenever I would like via the visual c++ source code....<br />
<br />

</div>


sorry but I'm not sure I understand.

I would like to know if I can execute the command to comapct and repair the mdb file whenever I would like via the visual c++ source code....



<div>
what I am saying is that I don't think you can via MFC - you will have to go via Jet - did you look at the articles I posted?
</div>


what I am saying is that I don't think you can via MFC - you will have to go via Jet - did you look at the articles I posted?

<div>
<div class="content wysiwyg-content">
hi <br />
I have a question.<br />
I built an MFC application that connects to an access database by ODBC connection.<br />
I also created MFC classes that inherits the CRecordset <br />
class.<br />
<br />
The problem is that when I delete all the records in a certain table, the size of the database does not get smaller.<br />
I need to compact and repair the database.<br />
My question is if there any way to update the size of the mdb database by SQL qurey or by any other way...<br />
<br />
thanks alot !!!!<br />

</div>
</div>


hi 
I have a question.
I built an MFC application that connects to an access database by ODBC connection.
I also created MFC classes that inherits the CRecordset 
class.

The problem is that when I delete all the records in a certain table, the size of the database does not get smaller.
I need to compact and repair the database.
My question is if there any way to update the size of the mdb database by SQL qurey or by any other way...

thanks alot !!!!


compact and repair

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.