Converting from 97 to 2002 and file size

C

Curious D

Can anyone explain why an 8Mbyte database grew to 22
Mbytes after beign converted to Access 2002?

Conversion was done in three steps Acces 97 -> 2000 ->2002.
I've seen the database start at 8 Mbytes, then become 5
MbYtes after compacting and end up 22MBytes !!!

Thanks
 
R

Roger Carlson

One thing is that Access 2000 and above stores text field in unicode, which
uses twice the space. If you go into your tables and set the Unicode
Compression property of your text fields to Yes, you may get some size
reduction after compacting. Still, 22MB is not that large for a database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query error after converting 3
convert access 97 database to 2003 2
Converting Access 97 to Acees 2003 & get conversion Errors 1
Converting Access 97 to 2000 not efficient ? 2
Conversion from Access 97 to 2003 & get a "Conversion Errors" tabl 0
Problem with Acc 2003 to Acc 97 conversion 6
Database Size difference after execution 0
Converting from Access 2000 to Access 2002 5

Top