[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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