I have a database of roughly 5000 company records. related to each of
those records are multiple-per-company records of products. for both
the products and the companies i would like to store reviews and
descriptions. there would be one description per company and product
but multiple reviews of both. I have the records all stored in Access
at the moment, but i am hesitant to store the descriptions/reviews in
the same database because of speed and file size. Would i be better
off storing all the descriptions/reviews in XML and just call them when
the particular record is retrieved? or would it be fine to just store
all those in a separate database? maybe just another table will do?
what is the best way to structure this?
--
virtuapetePosted from
http://www.pcreview.co.uk/ newsgroup access