?
Solved

Modify and Save Word File Stored in Table

Posted on 2013-11-19
5
Medium Priority
?
496 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

862 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