1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Development Access 2010 Linked Files

Discussion in 'Software' started by andrewbarke, 19 Jul 2011.

  1. andrewbarke

    andrewbarke What's a Dremel?

    Joined:
    5 Aug 2010
    Posts:
    139
    Likes Received:
    3
    hi all,

    i'm currently in the middle of developing an access 2010 database for the company that i work for. part of their specification is to be able to store files within the database, but after i explianed the whole 2GB limit etc, they settled on having a list of file names and there respective location as a link. (hope that makes sence, if not i will explain in more detail)

    now the problem, i've managed, through the use of VBA to enable the user to select the file and store it in a table, this work fine for word, excel etc. documents, but when i store a pdf it stores fine, but the link doesnt work, but if i manually add it to the table, the link work fine, so what have i missed (if anything).

    Thanks for any and all help!!
     

Share This Page