Connecting Tech Pros Worldwide Forums | Help | Site Map

97->2K conversion causes large size increase

Brian Hansen
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

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.com> 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
Guest
 
Posts: n/a
#3: Nov 12 '05

re: 97->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
Closed Thread