Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Access frontend to a SQL Server database - need to attach files

Hello,

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.

Thanks
0
mrneilbarton
Asked:
mrneilbarton
  • 2
1 Solution
 
chapmandewCommented:
I would just store the path to the file in the database and make it a link on an Access form.  Anytime they click the link, the actual document would be opened through an Access command.
0
 
mrneilbartonAuthor Commented:
Currently they use a linked table in Access, not a form.

Can I create a form that allows them to view and query data as the linked table does, but has this extra functionality?
0
 
chapmandewCommented:
Sure, that is what I was talking about.  You use the data from the linked server to put on the form, when the user clicks the link (data provided by the db) then you can bring up the file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now