Access frontend to a SQL Server database - need to attach files
Posted on 2008-06-25
I have a client who uses an Access database.
We have setup a SQL Server database for them (for their website). They currently access this data via a ODBC linked table in Access.
This works ok. However, they now want their database to hold CV's (resumes) for people, i.e. Word docs, pdfs. They want to be able to find a person on their database, and then click on a field (or whatever) and view the attached cv for that record. Is this possible using the current way of accessing the database? Any ideas on the best way to achieve this functionality would be great.