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

[Arno R]

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

[Trevor Best]

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 ?

[Arno R]

"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

[Lyle Fairfield]

"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

[David W. Fenton]

"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/

[Arno R]

"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