Is it possible to store .pdf files in an access table
in [Forms]
|
From: mls via AccessMonster.com on 27 Jan 2010 12:12 I am using ACCESS 2000 and checking to see if I can store .pdf file in the same table where I store my test results. If so how I can I do that? If not in ACCESS 2000 is it possible with ACCESS 2007? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1
From: Dorian on 27 Jan 2010 13:11 Why would you want to? Why not store the PDF file in a folder and just store the hyperlink to the files location in the database. Storing other files in an Access database, even if it was possible, would quickly lead to a huge and inefficient database file. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "mls via AccessMonster.com" wrote: > I am using ACCESS 2000 and checking to see if I can store .pdf file in the > same table where I store my test results. If so how I can I do that? > > If not in ACCESS 2000 is it possible with ACCESS 2007? > Thanks > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1 > > . >
From: johnlute on 27 Jan 2010 13:14 On Jan 27, 12:12 pm, "mls via AccessMonster.com" <u55943(a)uwe> wrote: > I am using ACCESS 2000 and checking to see if I can store .pdf file in the > same table where I store my test results. If so how I can I do that? > > If not in ACCESS 2000 is it possible with ACCESS 2007? > Thanks > > -- > Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1 I don't know if there's a way or not but I would suggest creating a related "attachments" table where you can store hyperlinks that link to your PDF files that are stored elsewhere (which is where they *ought* to be anyway).
From: Mark Andrews on 27 Jan 2010 15:51 Access2007 yes easy just add an attachments field, then on the form you easily get all the bells and whistles to browse for and add the file. You can also use code to automatically add or remove attachments in access 2007. However I agree, LARGE amounts of file storage should always be done outside of the database (no matter what version of Access). An attachment here or there in Access2007 is just fine. Mark RPT Software http://www.rptsoftware.com "mls via AccessMonster.com" <u55943(a)uwe> wrote in message news:a2bee0c4295e4(a)uwe... >I am using ACCESS 2000 and checking to see if I can store .pdf file in the > same table where I store my test results. If so how I can I do that? > > If not in ACCESS 2000 is it possible with ACCESS 2007? > Thanks > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1 >
From: mls via AccessMonster.com on 28 Jan 2010 08:44 Thank you. I have one pdf for each specimen so I think it would be good if I just store the reference in my table. can some one give me an example of how I can create the hyperlink? Mark Andrews wrote: >Access2007 yes easy just add an attachments field, then on the form you >easily get all the bells and whistles to browse for and add the file. You >can also use code to automatically add or remove attachments in access 2007. >However I agree, LARGE amounts of file storage should always be done outside >of the database (no matter what version of Access). An attachment here or >there in Access2007 is just fine. > >Mark >RPT Software >http://www.rptsoftware.com > >>I am using ACCESS 2000 and checking to see if I can store .pdf file in the >> same table where I store my test results. If so how I can I do that? >> >> If not in ACCESS 2000 is it possible with ACCESS 2007? >> Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1
|
Next
|
Last
Pages: 1 2 Prev: Import multiple forms, queries from another database Next: How to update underlying file |