By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

97->2K conversion causes large size increase

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Wed, 28 Jan 2004 19:00:38 GMT in comp.databases.ms-access, "Brian
Hansen" <an******@aol.com> wrote:
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


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.
Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.