Solved

Modify and Save Word File Stored in Table

Posted on 2013-11-19
5
454 Views
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.
Lisa
Database1.accdb
0
Comment
Question by:digigeek
  • 3
  • 2
5 Comments
 
LVL 21
ID: 39660643
Lisa,

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:  http://www.efilecabinet.com/


ALso check ou the free version of Alfresco  ( http://www.alfresco.com/products/document-management ) They do have a free version.
0
 

Author Comment

by:digigeek
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,
Lisa
0
 
LVL 21

Accepted Solution

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

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)
Description      
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  ( http://www.alfresco.com/products/document-management ) 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.



.
0
 

Author Comment

by:digigeek
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.
Lisa
0
 

Author Closing Comment

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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 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