File attachment control / storing attahcment to SQL 2005

mganci350 — Tue, 01 Jun 2010 18:43:25 GMT

I have a form with a datasource of MS SQL 2005.

The form uses a master detail config to two tables in the database.

In the master table I have a field of VARBINARY(max) where I would like to store and retrieve attachments when records are saved and queried.

I am pretty sure out of the box this functionality doesnt exist and my only options would be third party like Qdabra or modifying control code.

I am a DBA and not a programmer and although I feel like I am technically inclined,all of the solutions I have read do not give me enough of a starting point to tackle this.

When I choose properties on my controls, I believe the code that pops up is jscript.

Does anyone have any tips or advice on how to tackle this?

Thanks for the help!

Mark

Controls

File attachment control / storing attahcment to SQL 2005