Attachment Query

[unclefink]

I have a table for employees with a field that has an image attached directly to the database of each employee. I was wondering if it was possible and if so how to do a code in a query to tell me "Yes or No" indicating wheter or not an attachment is associated to a specific indviduals record.

 

[mahenkj2]

http://stackoverflow.com/questions/...nts-from-attachment-field-in-microsoft-access

see if it helps.

 

[JRickman]

I have a more basic question regarding the attachment data type. I'm using Access 2010 and would like to use this data type. However, I do not see "attachment" in the drop-down list when choosing which data type to use. Anyone have an idea why this is happening?
Any help would be appreciated as we have a need to reference other files.
Thank you, Jim

 

[Trevor G]

You need to make sure the database is saved as 2007 or 2010, not as 2003 format.

 

[JRickman]

Thank you for your response.
Next question: how do I save the database to a more recent version of Access?
When doing a "Save Database As" of the database, the only option presented in "Save as type" is "Microsoft Access Database".
Thanks, Jim