Solved

Modify and Save Word File Stored in Table

Posted on 2013-11-19
5
428 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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…
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

744 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

11 Experts available now in Live!

Get 1:1 Help Now