compact a Microsoft Access database through odbc

[Michael Meckelein]

Hi,

My csharp application access a MS Access database through odbc connection.
Is there a way to compact the Access database after deleting records using
the odbc connection?

I found out how to do this with Microsoft Jet and Replication Objects
Library [1], but unfortunately it seems that there is no way with ODBC.

Any glue how this can be achieved are very welcome.

Michael

[1] How to compact a Microsoft Access database by using Visual Basic .NET

http://support.microsoft.com/default...;en-us;Q306287

[Michael Meckelein]

> My csharp application access a MS Access database through odbc connection.

Is there a way to compact the Access database after deleting records using
the odbc connection? [snip] Any glue how this can be achieved are very welcome.

I have done a lot of research about this topic. Unfortunately I found no
solution. I found many issues on this topic. Some people use
SQLConfigDataSource [1] to compact the database via odbc. But in my case I
have to use an already existing system DSN. The path to the database is
unknown. Therefore I can't use this approach nor the JetEngine.

Any hint/suggestion/... is highly appreciated.

BTW: Just have the idea to read out the database path from the ODBC source.
Is this possible? Then I can use this as a workaround, read out the path and
then use theJetEngine.

Thanks in advance,

Michael
[1] SQLConfigDataSource(NULL,ODBC_ADD_DSN,(LPSTR)"Micr osoft Access Driver
(*.mdb)",
"COMPACT_DB=C:\\source.mdb C:\\dest.mdb General\0\0");