davidatlamont
asked on
Using container field to store files
I'm using FM Pro 8 and have DB's hosted with FM Server 8 on a Powerbook G4 using OS X.
I have a job DB that's used for job tracking, providing approval process, etc. Up to this point all job materials (Press releases, brochures, etc.) have been stored on a company server and users must access FM DB for current status, sign-off, etc. but access materials on server. I would like to start adding these files (mostly word, pdf, etc.) directly into FM DB so that all materials are easily available.
I understand I can use a container field to store files but need suggestions on whether to store file or just reference. If I use the "Store only a reference to the file" feature I have a problem with users accessing these files since they're connecting to FM DB remotely. If I store actual file in FM DB they need to use the "Export Field Contents" feature and work on document locally which raises concerns about multiple users 'exporting' and working on file simultaneously.
Hope this makes sense.
Thanks.
I have a job DB that's used for job tracking, providing approval process, etc. Up to this point all job materials (Press releases, brochures, etc.) have been stored on a company server and users must access FM DB for current status, sign-off, etc. but access materials on server. I would like to start adding these files (mostly word, pdf, etc.) directly into FM DB so that all materials are easily available.
I understand I can use a container field to store files but need suggestions on whether to store file or just reference. If I use the "Store only a reference to the file" feature I have a problem with users accessing these files since they're connecting to FM DB remotely. If I store actual file in FM DB they need to use the "Export Field Contents" feature and work on document locally which raises concerns about multiple users 'exporting' and working on file simultaneously.
Hope this makes sense.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
At least you can open them automatically with a script which will lock the record while editing.
If you store the file in the DB, the Db will be very big and you can't activate the field to open it automatically.
But then you need all yr macs, including the remote machines to be able to access the file ref, ie a public afp folder (ftp could work, but finders'ftp is read only).
If is one of the rare situations where the windows version is far better using OLE: you can store the internally to DB and edit it from within the DB, even remotely.