Compacting Databases

[JeffSM]

Hi!

My MDB has about 4MB and when I compact it don't be small.
I use this code:
DBEngine.CompactDatabase cTmpFile, m_DataBaseName

When I use access it down to 2MB??

What I'm doing wrong?


Thanks in advance.
Jefferson

[MartinLiss]

Your code will compact cTmpFile and place the compacted version in whatever name m_DataBaseName resolves to. If it doesn't have a path associated with that name it will wind up in app.path. Did you perhaps mean to do DBEngine.CompactDatabase m_DataBaseName, cTmpFile
instead?

[JeffSM]

Thanks!
I gonna see that!

Jefferson