Modify and Save Word File Stored in Table

Posted on 2013-11-19
Last Modified: 2013-11-19
Dear Experts,

My name is Lisa and I am new to Experts Exchange.

I am helping a friend develop the capability to open an attachment file from a document table (tbl_Document) and then edit and save it as a PDF and restore it in another table (tbl_Register) for government auditing and mailing purposes.

She is using office 2010 Home & Business and has Access 2010 installed.

I have taken the liberty of enclosing a sample db with the two tables which includes the sample Letter in docx format stored in the table called tbl_Document.

Any help or guide on this would be greatly appreciated.

Wishing well.
Question by:digigeek
  • 3
  • 2
LVL 21
ID: 39660643

I think most will agree ha the Best Practices is to NOT store the documents inside the table. You should only store the path to the file.

I have worked with many document management systems and create several.  I have yet to see a good one store the documents in the database.

I know of one situation where a Access database (.accdb) became corrupted and they lost all their documents because they were stored in the only in the database. They did not have a recent backup so they lost a lot of stuff.

If you must store them in the database I would urge you to upsize the back end to MS SQL Server 2012.

I would recommend purchasing a good document manageme3nt system. Once you have learned how the work, if you feel that you have outgrown them, then it may be time to re-create your own.

Here is an example of what you are trying to create:

ALso check ou the free version of Alfresco  ( ) They do have a free version.

Author Comment

ID: 39660753
Dear HiTechCoach,

Thanks for your informative reply.

All points noted.

With that said, moving towards your suggested solution of storing the documents outside the db in respective folders, is this easy to do?

I  don't want to incur any cost as I am doing this as a favour for a friend (and learning myself). I want to be sure that she can access the files directly from a form in Access, modify them, then save them to their respective external folder etc.

Is this an easier solution, if so, do you have any tips?

Wishing well,
LVL 21

Accepted Solution

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 39660831

There is not an easy solution for this. Especially when you need to deal with revision control,

This will require VBA coding. What is you VBA coding skill level?

I have created this example:

Document Links 2 (Click Here)
This is an update to the basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink  method.

This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.

***** Because it doesn't use the hyperlink data type, this new version stores the path in a way that allows the folder to be easily moved.

I would still urge you to install the free version of Alfresco  ( ) so you can learn more about what you are attempting.

This also applies to programming:
WARNING: 5 Reasons why you should NEVER fix a computer for free.


Author Comment

ID: 39660966
Hi again,

Thanks so much for your help with this. It is very useful.

I think what you have provided in your sample db file will suffice for me to get started.

I used to program in VBA a lot but, I am rusty as hell and only worked with Office 2k and 2003.

I have also bought Access 2007 VBA Programmers reference on e-bay this morning to help me learn more as well as I am keen to get back into it. I am a stay at home mother and am wanting to get back into work.

I like your last link. It makes a lot of sense! Freebies are dangerous I agree. But, I have known this friend for a very long time and she has done a lot for me so I would like to return some of her favours in good faith.

Thanks again.

Wishing well.

Author Closing Comment

ID: 39660968
Great help from a very knowledgeable Expert. Thanks HiTechCoach!

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now