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

"Arno R" <arraNOcomSPAM@xxxxxxxxxx> wrote in
news:4446a28e$0$2021$ba620dc5@xxxxxxxxxxxxxxxxxxx:


"Trevor Best" <googlegroups@xxxxxxxxxxxx> schreef in bericht
news:44469bec$0$8336$da0feed9@xxxxxxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: mdb-size and zip-size (zip hardly smaller)
    ... In my original post I said: ... I deleted all objects in my original mdb. ... I compacted the mdb and imported all the objects from the backup again. ... and adjusted the security-settings for all new objects for all users and groups. ...
    (comp.databases.ms-access)
  • Re: how to get from an MS Access app to vb.net?
    ... Obviously with an mdb a backup simply means copying a file! ... Frankly, if you want to go dotnet, then SQL Server is the smart way ... Do not, however, get the idea that I am wholeheartedly endorsing dotnet! ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Maintenance Interval does not work
    ... " Backing up an Exchange 2000 MDB halts theonlinedefrag of any MDB within ... that storage group (they restart if the backup finishes before themaintenanceinterval passes). ... any MDB within a storage group doesnotconflict with themaintenancetimes ...
    (microsoft.public.exchange.admin)
  • Re: Maintenance Interval does not work
    ... " Backing up an Exchange 2000 MDB halts the online defrag of any MDB within ... where one is running online maintenance, and online backup is started ...
    (microsoft.public.exchange.admin)
  • Re: Dont have permissions to import
    ... Change your workgroup back to your secure mdw. ... (if you had a backup before you secured it, you could just remain joined to system.mdw and restore the backup). ... To unsecure, grant full permissions to every object, to the Users Group. ... create a new mdb and import everything from your mdb. ...
    (microsoft.public.access.security)