97->2K conversion causes large size increase

[Brian Hansen]

When I tried converting my Access 97 db to 2000, the size of my database
increased from 35MB to 70MB even after compacting and repairing. I tried
enabling Unicode compression on the table and it only decreased the size of
the database by 2MB. It seems to be only one large table that is inflating
in size. Please let me know if you have any suggestions. Thanks.
Brian

[Trevor Best]

Re: 97->2K conversion causes large size increase

On Wed, 28 Jan 2004 19:00:38 GMT in comp.databases. ms-access, "Brian
Hansen" <andonebh@aol.c om> wrote:
[color=blue]
>When I tried converting my Access 97 db to 2000, the size of my database
>increased from 35MB to 70MB even after compacting and repairing. I tried
>enabling Unicode compression on the table and it only decreased the size of
>the database by 2MB. It seems to be only one large table that is inflating
>in size. Please let me know if you have any suggestions. Thanks.
>Brian
>[/color]

Try importing everything into a new database, that's about as small as
it will go, other than that unless you download it on a modem on a
regular basis I wouldn't worry about it.

--
A)bort, R)etry, I)nfluence with large hammer.

[Tony Toews]

Re: 97-&gt;2K conversion causes large size increase

Brian

Please ignore the posting from starwars. He is rather disruptive.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm