i want to add a word/text file in database(MS-Access), for this i am using datatype ole object for that particular column.
i am using a text box to catch the file name and the complete path of the file and putting the value of textbox in that table column. But when i open the table to see the column value then it shows an empty value ie. nothing stored in that.
If i use Hyperlink datatype for that column then the path of the file is saved in the table but it could not get open by clicking at the link.
i will really appreciate if anyone can suggest me how to do this?
Thanks in advance.