A question of Access Database

[shiyuwei]

When I use ODBC for Micorsoft Access databases,I meet a big problem.If I read or write datebases for thousand of times,it will become very very big.(for example from 200K to 200M)
But if I use Access to compress it ,it can return to 200K. I can do nothing for it now.Could
you give me some advice? Do you know how to compress database in program? Thank you for your attention.

[Paul Burns]

look at CDaoWorkspace::CompactDatabase()

[d_wzrdv_z]

If you have actually done this I'd love to see the code - I have a problem, because I'm using the default workspace and the doco is rather sketchy of the CDaoWorkspace
Cheers,
HAV