Navigation:  Data Types > Documents

Documents can be stored in the database and retrieved through ESdat by double clicking on the relevant field the document is to be loaded into.  In Access versions only the path to the file is stored; SQL Server versions additionally have the option for the file to be physically stored in the database.

 

In order for ESdat to recognise the field as requiring a file path or file the fields must be named as follows:

 

Store Path to the file:                

the field name must end in "_path" and the field must be text

 

Store the file in the database (SQL Server versions only):        

The field name must include the words "_report", "photo" or "document" or the full field must be "Reports" or "Report_ID".

The field type must be integer (or some other numeric).

The system can be set up (Setup - Document Management) to either store documents internal to the database, or in a centralised folder.