I want to create an application that use Access 2007 as the front-end and SQL Server 2005 as the back-end. I want to use this application to store real estate properties information and sample pictures for each property.
Access has size and performance limitation. So storing data in Access is not a good option. I have used the attachment object type and attachment data type to load and view the pictures in Access. It works really well. Is it possible to mimic the same functionality with Access and SQL Server?
Thanks,
Ken