Attachments

[Learn2010]

I have an MS Access front-end and a SQL back-end for a student database. I have no control over the SQL. I am going to be storing images on a shared drive. Here is what I would like to do.

Store the attachments in an Access table.
Add a field to that table with the studentid to identify the attachments.

When I append the student record to a table behind a form, can I attach the records from the Access table to that form so that all the attachments for that student is available on that form?

I hope this is clear.

Thank you.

 

[Minty]

I wouldn't store the attachments in the database, simply store the file location as a text field.

You can then open the attachment easily. If they are all images you can still view them on an access form.

This avoids trying to link two data sources, and stops your access database growing in size quickly - image storage takes up lots of space.

 

[Learn2010]

That is what I meant to say. I want to store the link in a table. First, how do I do that? Secondly, can I pull that link into another table by querying the student record with a link to this table?

Thanks.

 

[Minty]

As long as there is a field that ties the two records together, even if it via another intermediary table or query, then you can always make a link.