By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

mdb-size and zip-size (zip hardly smaller)

P: n/a
Hi all,

I have this newly designed app here (A97)
This app is 7.298 kb wich seems like a normal size to me.
But zipped the size is 7.262 kb which I consider *very* strange.

I am used to a zipped size of 3-4 times smaller than the original mdb

I tried repair-compact, decompile and the like. Still the same.
Even when all the forms are SavedAsTxt-LoadedFromTxt it is the same.
The zip is only a few kb smaller. What could be the cause of this ??

Only when I create a new mdb and import all the objects again I am getting figures like
6.228 kb for the mdb and 2.382 kb for the zipped mdb.
This looks like 'normal' behaviour to me.
Unfortunately the security-settings (ULS) are lost when I import everything in a new file.

Any ideas ??

Arno R
Apr 19 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Arno R wrote:
Hi all,

I have this newly designed app here (A97)
This app is 7.298 kb wich seems like a normal size to me.
But zipped the size is 7.262 kb which I consider *very* strange.

I am used to a zipped size of 3-4 times smaller than the original mdb

I tried repair-compact, decompile and the like. Still the same.
Even when all the forms are SavedAsTxt-LoadedFromTxt it is the same.
The zip is only a few kb smaller. What could be the cause of this ??

Only when I create a new mdb and import all the objects again I am getting figures like
6.228 kb for the mdb and 2.382 kb for the zipped mdb.
This looks like 'normal' behaviour to me.
Unfortunately the security-settings (ULS) are lost when I import everything in a new file.

Any ideas ??


Have you tried a /decompile ?
Apr 19 '06 #2

P: n/a

"Trevor Best" <go**********@besty.org.uk> schreef in bericht news:44**********************@news.zen.co.uk...
Have you tried a /decompile ?


In my original post I said:
I tried repair-compact, decompile and the like. Still the same.


Also: I just made a backup of the mdb
I deleted all objects in my original mdb.
I compacted the mdb and imported all the objects from the backup again.
(This had to do with the security-settings for new objects that I wanted to keep this way)

But: Still the same problem !!

I created a new mdb, and adjusted the security-settings for all new objects for all users and groups.
Imported all the objects from the same backup and now the zip is 2257 kb. OK !
Still need to adjust some security-settings for a few special queries and so but problem is solved.

Still stunned! What 'special' setting did I trigger in the database?

Arno R

Apr 19 '06 #3

P: n/a
"Arno R" <ar***********@tiscali.nl> wrote in
news:44**********************@text.nova.planet.nl:

"Trevor Best" <go**********@besty.org.uk> schreef in bericht
news:44**********************@news.zen.co.uk...
Have you tried a /decompile ?


In my original post I said:
I tried repair-compact, decompile and the like. Still the same.


Also: I just made a backup of the mdb
I deleted all objects in my original mdb.
I compacted the mdb and imported all the objects from the backup
again. (This had to do with the security-settings for new objects that
I wanted to keep this way)

But: Still the same problem !!

I created a new mdb, and adjusted the security-settings for all new
objects for all users and groups. Imported all the objects from the
same backup and now the zip is 2257 kb. OK ! Still need to adjust some
security-settings for a few special queries and so but problem is
solved.

Still stunned! What 'special' setting did I trigger in the database?

Arno R


I think you said you had done the saveastext loadfromtext thing on all
your objects. Your db will be as small as possible now because there are
zero extraneous objects/code in it and it is uncompiled. When it is
compiled, it will get bigger.
Zipping looks for similar strings and notes their location. If a db is
encrytped it's unlikely there are any similar recognizable string
patterns (else the encryption would be tres easy to break). So you get no
compaction, plus you get the zip overhead; hence a larger db. I never use
security by my memory tells me that when Access security is applied,
encryption occurs. I could be way wrong there, but if no encryption then
what good is the security?

ramble ramble .... snore snore

--
Lyle Fairfield
Apr 19 '06 #4

P: n/a
"Arno R" <ar***********@tiscali.nl> wrote in
news:44***********************@text.nova.planet.nl :
I have this newly designed app here (A97)
This app is 7.298 kb wich seems like a normal size to me.
But zipped the size is 7.262 kb which I consider *very* strange.

I am used to a zipped size of 3-4 times smaller than the original
mdb

I tried repair-compact, decompile and the like. Still the same.
Even when all the forms are SavedAsTxt-LoadedFromTxt it is the
same. The zip is only a few kb smaller. What could be the cause of
this ??

Only when I create a new mdb and import all the objects again I am
getting figures like 6.228 kb for the mdb and 2.382 kb for the
zipped mdb. This looks like 'normal' behaviour to me.
Unfortunately the security-settings (ULS) are lost when I import
everything in a new file.


If it's secured, then it's encrypted, and encrypted files simply
don't compress (for fairly obvious reasons).

If it's not encrypted, then it's not really secured, and I don't
know what the problem would be.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Apr 20 '06 #5

P: n/a

"Lyle Fairfield" <ly***********@aim.com> schreef in bericht news:Xn*********************************@216.221.8 1.119...
I never use
security by my memory tells me that when Access security is applied,
encryption occurs. I could be way wrong there, but if no encryption then
what good is the security?

Lyle Fairfield


Encryption does not occur when security is applied. It is two different things.
==> But I had this FE encrypted indeed without even remembering I did ... <shame on me>

I agree that the security 'improves' with encryption (but it is still no good is the common idea here)
I use the security here mainly to track the admin-users and grant them some special permissions.
I do not use it to secure the design (I deliver an mde) or data.

Thanks
Arno R
Apr 20 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.