Solved Attaching documents to each record

[georg0307]

Dear All,

could you please help me with the following matter?

I'd like to attach several custom documents (*.pdf and other) to each record of my Database. Is it possible do it avoiding it becoming too heavy?

Thanks oin advance,

 

[Ranman256]

I advise against it. Your db will fill up quick.
instead, save the path to the documents.

 

[boerbende]

Agree wit Ranman.
My solution is also to keep the documents stored on the network and to save the whole path to the document in a text field
To open the document I use one line of code in for example a doubleclick event on the document name in a form

Shell "C:\WINDOWS\explorer.exe """ & YourPath & "", vbNormalFocus

 

[theDBguy]

Is it possible do it avoiding it becoming too heavy?

It's possible to add documents, but it won't be possible to avoid making it heavy. Follow what the others said and don't add actual documents.

 

[georg0307]

Dear All,
solved!!!

 

[theDBguy]

Dear All,
solved!!!

Good luck with your project.