Showing results for 
Search instead for 
Do you mean 

lookup for attachments

Avid Listener
Posts: 49
Country: aus

lookup for attachments

hi all
just a quick question
can we do a lookup to find all the attachments in the database - if so how ?.
version 10.01.199
thanks in advance
Nickel Contributor m4y
Nickel Contributor
Posts: 539
Country: Belgium

Re: lookup for attachments

Do you want to find all contacts with attachments or just attachments??

All attached files are located in the subfolder databasename-database files folder/attachments.

To find all contacts with attachments, go to Lookup > Contact Activity menu.

Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | | }
New Member
Posts: 1
Country: USA

Re: lookup for attachments

I am wokring on a conversion project and I am stuck on attachments and where they are located / how they are stored. I know the tbl_attachment is the table it is stored in. Attachment ID, File Name, etc. I am looking for the document itself. I thought it would reside in the database table as some binary object but I can not find it.


Are the attachments stored on the box itself?


(All attached files are located in the subfolder databasename-database files folder/attachments.)


If so, how do you go about actually extracting the attachments? Do a simple loop through the tbl_attachment table and then look in the appropriate folder based on the 'filename'?