MDB created via vba problem

[TrollBro]

I can't figure this out - I auto-create and mdb in A2K using a vba routine and transfer tables to populate it with about 8 tables. Size is 187 meg. mdb seems file - data looks ok etc. when I zip it using winzip it actually INCREASES the zipped file size slightly. Anyone have any ideas or seen this before? Thanks!

 

[alvechurchdata]

WinZip can only reduce the size if it can find some redundancy to remove. It then has to add its own admin overhead. If you're staring with a file that has no recognizable patterns in it then Winzip can't find any way of reducing its size and you'll get a zipped file holding the original data plus the WinZip overhead.

I've seen it with things like graphics files that are already in a compressed format but not with an mdb. Usually they compress pretty well.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[JerryKlmns]

TrollBro

Since you do that with code, include a compact & repair procedure (check in help what compact & repair does) without encryption. Then zip it. If you use encryption zipping wont do any good.

 

[TrollBro]

THANKS FOR THE IDEAS - you pointed me in the right direction and whaddaya know - dbEncrypt was specified in my code.

Set dbsNew = wspDefault.CreateDatabase(strDatabase, dbLangGeneral, dbEncrypt)