large database file size after new table addition

[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?

 

[fredg]

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?

Did you Compact the database?

Tools + Database Utilities + Compact and Repair

 

[Dirk Goldgar]

In

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?

What's the actual table definition? What are all the fields in the
table, and what are their types and sizes?

 

[Guest]

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.

 

[Tony Toews [MVP]]

AFAIK Zip Codes don't cross state lines;

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/