Scan documents DB

[syedadnan]

Regards,

I am looking to prepare a DB to save scan documents, like property papers, identity cards, payment cheques etc but the problem i am feeling before the designing of the program that scan attachments in table will cause early full capacity of table, is it in fact ?? if i split the table then will this work ? I need some suggestion over this

 

[arnelgp]

save only the path\filename of the document to textfield.

 

[syedadnan]

save only the path\filename of the document to textfield.

Thanks for the reply

Could you please elaborate this in detail as i am not getting what you said

 

[arnelgp]

possible table structure:

ParentID...............LongInteger............Refers to the PK number on main table
DocDesc...............Text........................Description of document
DocPath................Text........................The path\filename of the document.

 

[syedadnan]

possible table structure:

ParentID...............LongInteger............Refers to the PK number on main table
DocDesc...............Text........................Description of document
DocPath................Text........................The path\filename of the document.

Will this DocPath a hyperlink to open that scan doc on click

 

[NauticalGent]

Will this DocPath a hyperlink to open that scan doc on click

Pardon me for jumping in, but the answer to your question is yes. If you store a hyperlink in the text field, it will direct you to the location of those files.

A VERY efficient way to make documents accessible and a much better option then attachment fields.

Best of luck!

 

[SjCc]

save only the path\filename of the document to textfield.

Hi Dear, hope you are doing well

I need your assistance in developing this at;

https://www.access-programmers.co.uk/forums/showthread.php?t=308538