Shared drive path to save attachments

[zaffar_mughal]

Hello All,
Need your help to solve the problem of saving attachments to shared drive.


I have a order database and i receive invoices from suppliers and there are different users updating the records. I want to save the invoices in shared folder so all of the users can view/access the invoices. Thanks in advance...

[June7]

So what is the issue? What 'attachments'? What is an 'invoice' - PDF, JPG, Word doc? Options are to save objects in Attachment field (not advised) or to save the path/filename in text field.

[zaffar_mughal]

Actually, users are scanning the invoice and saving in JPG, i dont want to save attachments in the database because of the maximum size issue which is 2GB. Im looking for a way where any user can scan and add the attachments but attachments should be saved in separate folder not in the database.

[June7]

User scans the image, names the image, saves to folder. Then user must do data entry to save the path\filename to record. Will all images by all users go into one folder? If so, the full path does not need to be stored in record, just the actual filename.

These images can then be dynamically displayed on form or report with an Image Control. The Image Control ControlSource property can be an expression that concatenates the static path to the filename field. Use UNC pathing, like:

="\\server name\folder path\" & [fieldname]

Or use code to treat the URL as a hyperlink to open the image in viewer app. Review http://allenbrowne.com/func-GoHyperlink.html