Access sp1 versus sp2

[ld_b]

I have a mdb file w/ a size of 18 MB. When opened and saved using sp1 it
remains the same size. After opening the file on any computer running sp2,
the file size changes to 5 MB.

The record counts are the same. Is there some form of database compaction
occuring? Is any data being lost? Are there any documents detailing
differences between Access sp1 and sp2.

LB

 

[Jerry Whittle]

Don't worry about the size of the database or losing data with SP2. It isn't
happening. Be more worried about the computers with only SP1 installed as SP2
fixes a lot of bugs.

 

[david]

The record counts are the same. Is there some form of database compaction

Yes, probably. This was the original reason for the 'decompile' option.

To discard old internal versions of things when the internal version of
Access 95 changed.

Good to see that sp2 has done that automatically.

(david)