April 2, 2008 at 10:13 pm
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 documents (merge files) that get data from this Access database and today these documents 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 documents, since all the data needed for the documents 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 documents 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 documents 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.
April 3, 2008 at 1:18 pm
Upgrade to SQL Server, then do these two steps:
1) Create a View on SQL Server that emulates your old Access table with everything in it.
2) Change your word ODC from your Access table to the SQL Server View.
That should be all that you have to do.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 3, 2008 at 6:33 pm
It makes a lot of sense, thanks.
April 6, 2008 at 12:14 am
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply