Solved

Storing files in FM Database

Posted on 2006-10-24
5
299 Views
Last Modified: 2010-04-27
I had earlier inquired about inserting files in FM DB, see link below.

http://www.experts-exchange.com/Databases/FileMaker/Q_21872743.html

The following was suggested:

*****
This problem can be alleviated by using a check-out//check-in system, where the user "requests" to export the document, and it is then flagged as "locked", so no other users can access it until the first user finishes with it and replaces it. This is a bit more complex to set up, but it's not unreasonable, it just requires some scripting of the user interface.

The biggest problem with storing the files in the database itself is how much this will increase the size of the database files and affect performance. If the files are mostly small, it may not be a problem, but if you're dealing with huge desktop publishing files, for example, it's probably not worthwhile.

*****
I'm not worried about increasing the size of the database since it will only host files for open/active jobs (not more than 100 word or pdf documents).  I'm looking for help with the "check-out/ check-in system" described above.

Thanks.

0
Comment
Question by:davidatlamont
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 250 total points
ID: 17797527
If you intend for instance to let the user open the file by clicking on its name, just modifiy the image box as a button which changes the flag "busy/locked" and then opens the file. If the flag is already busy, then issue a msg saying it is... You then need another kind of validate button to reset the flag for further use. But why do you need this?? If the file is in a media field, it will be locked if somebody opens it anyway, as it does with any field.
0
 

Author Comment

by:davidatlamont
ID: 17797706
Let me state the basic need.  I have a job db that I would like to be able to add job materials (normally a word or pdf document) to so that various users can acess/edit while maintaining version integrity.  My understanding was that I should use a Container field to store the file (I want the actual file stored and not just a reference).  Am in confused?
0
 
LVL 28

Expert Comment

by:lesouef
ID: 17798552
no, this is correct.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

16 Experts available now in Live!

Get 1:1 Help Now