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
Printable View
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
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?
Thanks!
I gonna see that!
Jefferson