Attaching Files

[ipforlife]

This might be impossible, but I was wondering if there was a way to attach files to records on a form. I work for a marketing company and I have built a contact management database and I need to attach files such as letters and emails to records on a form. I also would like a list of files attached to that record to display also. I don't know if this makes sense or if it is possible. Any help would be greatly appreciated.

Nick

 

[bonekrusher]

Its possible. This is how I do it:

In the folder where my database is I have a folder called "files". The user can attach an infinite number of files to each record. They can either open them with activeX control or just open them. The database doesnt store the file (this will bloat your DB), rather I upload the files to the "file" folder, then record the link in a table.

Is this what you are looking for? If so let me know.

 

[ghudson]

I suggest that you avoid the ActiveX browser control. This should point you in the right direction...

Browse [Find a directory or file]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.