I?m using Access + SQL Server to develop a database application, and now need to show pictures in the database. For example, customer can upload a scanned drawing in jpg or bmp format, and the all other users can view the drawing and make their comments.
How can I realize this? I know first need to add a field in SQL Server database, with image data type. What should I do then in Access?