Access 97 vs Access 2003

B

bdkstag

Hi,

when I save a database in access 97 it's around 500kb but
when I save the same database in access 2003 it's get
about 1,5mb. How is this possible?
Can I change this?
 
A

Allen Browne

That's probably about right: Unicode takes two bytes to store one character,
and then another 50% inefficiency in the more recent versions.

You may be able to improve matters by opening your A2003 tables in design
view, and setting the Unicode Compression property to Yes for all Text,
Memo, and Hyperlink fields.
 
Top