I am trying to write a database application that allows me to catalogue a number of miscellaneous files, thus I would like to store the file itself (Excel, Word, PDF, MsAccess, text, executables…) in a database. I have the option of having (a)just a MsAccess database or (b) a SQL server back end and an MsAccess form as a front end. How should I go about setting up the database to accept attachments (what datatype?) and how do I set up the form to accept attaching and detaching of these files?
Your help will be greatly appreciated.
