For the last 7 years we have been using a piece of software that's
based on Access 2000. About two years ago I created several MS Word
do***ents (merge files) that get data from this Access database and
today these do***ents are a crucial part of our business, they are
used 90% percent of the time and basically we can't live without them.
The Access database has a major design flaw, it basically has one
table that contains most of the data. A well designed database would
have the same data in several tables. But this flaw turned out to be a
good thing when creating the MS Word do***ents, since all the data
needed for the do***ents are in one table. Everything works
beautifully.
Our software vendor released a new version of the software which uses
a well designed SQL Database, and they split that table into several
tables, as it should have been to begin with. The problem now is that
the do***ents I created will not work with the new software, therefore
we cannot upgrade a make use of all the other good things they
implemented.
I thought about creating an Access database and link it to the SQL
database, and try to gather all the data needed into one table or
query so I can point the merge do***ents to it.
I know that's a long story, but I think that's the only way to be
clear. I really need help with this, and I'm pretty sure there are
other better ideas I can get here.
Thank you.
Silvio.
www.silvioribeiro.com
|
