[Webinar] Streamline your web hosting managementRegister Today

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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