Where did all the other come from?

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have a couple of address databases. These are up to 2k in size. I
recently had another one sent over from another office as a CSV list. It
was only a couple of thousand entries - smaller than the others. When I
imported this into access I ended up with a file of 20k+ . The others I can
easily email to the printing dept - but this one is a bit big! Any ideas
about what I could have done wrong?

Thanks

--
_______________________________
Disclaimer:
By sending an email to ANY of my
addresses you are agreeing that:
1. I am by definition, "the intended recipient"
2. All information in the email is mine to do with as I see fit.
3. I may take the contents as representing the views of your company.
4. That this overrides any disclaimer or statement of confidentiality that
may be
included on your message.
 
I have a couple of address databases. These are up to 2k in size. I
recently had another one sent over from another office as a CSV list. It
was only a couple of thousand entries - smaller than the others. When I
imported this into access I ended up with a file of 20k+ . The others I can
easily email to the printing dept - but this one is a bit big! Any ideas
about what I could have done wrong?
Click to expand...

20k is a VERY small Access database! I haven't worked (seriously) with
one under 100k in quite a while.

Try Tools... Database Utilities... Compact and Repair. This will
compress out much of the waste space and overhead.
 
Using Access 2003 but the Access 2000 file format, a newly created MDB
containing nothing but the default system tables is 92 KB on my system. So
out of curiosity, I tried it with Access 2, and the result was 62 KB. I
don't know what those 2 KB files are, but I'll tell you what they're not -
they're not MDBs!

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top