It's me again, crying out for more computer help. I'm trying to create a database in Microsoft Access to track "stuff" in my house. I have the basic database pretty well worked out -- the table is done and I have about 60 records in it to test it, and I have a data entry form that's clean and neat and gets the job done. But ...
I'm migrating over to Access from Excel because I want the more flexible reporting capability, and because I really want to be able to include photos of the items for insurance purposes. And I can't figure out how to get the photos into the records.
In the interest of full disclosure (since in this case it may make a difference), I have been working in Access 2003, but I have Access 2016 on this computer. I would prefer to stay in 2003 because I loathe the ribbon menu structure in Office 2007 and newer, but from what I've read Access 2003 can't handle JPEG images so it's possible that I may be stuck using Access 2016. Ideally, I'd like to keep the actual image files separate and just have Access display (and print) from links to the external files, but if the easiest way to work is to just bring the files into the database itself ... so be it.
Do we have any Access gurus around here?