your database front-end

Object Fields

dbFront treats binary fields (Blob or VarBinary) as attachment storage fields with the expectation that you want to upload, view and download the attachments.

dbFront - Field Preferences - Object

On the Main tab you have the ability to set the basic preferences of Caption, Readonly and Required.

On the second tab named Object Details, you can specify the: 

  • Max Size: Sets the maximum file size of any attachment or picture that can be uploaded.
  • File Types: Allows you to specify the different file types that can be uploaded.
    dbFront will examine both the file extension (upon upload) and the file/field contents to determine what is being stored.

Object Fields will display as follows.   If a picture is available then a thumbnail of the picture will be displayed.   Otherwise an Icon will be shown depending upon the file type.

dbFront - Field Preferences - Image

Attachment Size

The maximum attachment size is determined by the database field.   But the maximum attachment size that can be uploaded is determined by your webserver setup.

IIS (Microsoft's Internet Information Server) uses two web.config settings to determine how much data it will allow you to send to the web server.  These settings have a security aspect because if they are set too large then it creates an easy avenue to launch a DOS (Denial Of Service) attack against the server.

Both settings need to be set correctly in order to allow users to upload larger attachments.

The first setting is:<httpRuntime maxRequestLength="51200" />.   This value is stored in KB so for a value of 50MB you would need to specify 51200.

The second setting is: <requestLimits maxAllowedContentLength="52428800" />.  This value is stored in Bytes so for a value of 50MB you would need to specify 52428800.

Below is an image showing the required changes so that the server will accept uploads up to 50mb.

dbFront - Field Preferences - Object

Next Steps

Once all of the field preferences are set as needed

Content you want the user to see goes here.