G
Guest
I have about 400 - 500 linked embeded objects (this includes Word docs, Excel
spreads, and many Adobe Documents). It's a rather large database in size and
its hitting the limitations that Access 2007 has, (i think) which is two gig.
I was worried the many memo fields and/or database design with indexes was
making it much bigger than it needed to be but, I think it's the linked docs.
I had the users of the database right-click in the table to make sure all
447 docs are "LINKED". and they are. They deleted any embedded docs so we
have only linked docs. To prove a point I did the following:
I exported the DOCTable to a new database, and WHAMMM sure enough, it's 1.92
gig, while my millions of records in the original database is only 1.97gig.
Why are linked documents taking so much room, how can prevent this w/o
changing the way my users import docs. Can someone help please!!
(e-mail address removed) PLEASE
spreads, and many Adobe Documents). It's a rather large database in size and
its hitting the limitations that Access 2007 has, (i think) which is two gig.
I was worried the many memo fields and/or database design with indexes was
making it much bigger than it needed to be but, I think it's the linked docs.
I had the users of the database right-click in the table to make sure all
447 docs are "LINKED". and they are. They deleted any embedded docs so we
have only linked docs. To prove a point I did the following:
I exported the DOCTable to a new database, and WHAMMM sure enough, it's 1.92
gig, while my millions of records in the original database is only 1.97gig.
Why are linked documents taking so much room, how can prevent this w/o
changing the way my users import docs. Can someone help please!!
(e-mail address removed) PLEASE