large database file size after new table addition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added a table to my database that is causing the database size to grow
tremendously. There are a total of 807,000 records of zip codes along with
corresponding latitude, longitude, city and state names.

I have set Unicode Compression to YES by all text fields. What other
settings or actions will help reduce database file size?
 
I have added a table to my database that is causing the database size to grow
tremendously. There are a total of 807,000 records of zip codes along with
corresponding latitude, longitude, city and state names.

I have set Unicode Compression to YES by all text fields. What other
settings or actions will help reduce database file size?
Click to expand...

Did you Compact the database?

Tools + Database Utilities + Compact and Repair
 
In
Susan said:
I have added a table to my database that is causing the database size
to grow tremendously. There are a total of 807,000 records of zip
codes along with corresponding latitude, longitude, city and state
names.

I have set Unicode Compression to YES by all text fields. What other
settings or actions will help reduce database file size?
Click to expand...

What's the actual table definition? What are all the fields in the
table, and what are their types and sizes?
 
AFAIK Zip Codes don't cross state lines; however, a zip code can be shared by
more than one city and a city can have more than one zipcode. Think New York.
I believe that this is was GeorgeCY was saying in another post of this
question.
 
Jerry Whittle said:
AFAIK Zip Codes don't cross state lines;
Click to expand...

I recall reading that are a few obscure cases due to small towns being
just across state lines.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top