Re: How to add PDFs to Access 2003 database?

Do the ones that don't open through your application open from the CD if you
double-click on them or open them from within Acrobat Reader? If not, it
would sound as though there was something wrong with the burn of the CD.

The fact that some work well makes me suspect that it's not something you
did. Unless there's some commonality about which ones open and which ones
don't, such as you've got more than one folder of documents, and all of the
documents in one folder open, and none of the documents in the other folder
open, in which case show us the code you're using.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"alinoiul" <alinoiul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC1ABA76-C3D0-4DE6-B25D-858DF665F6C6@xxxxxxxxxxxxxxxx
Thanks you. I have done this and everything works. I have a problem
still.
My boss wants the database on a cd, so she can read the articles at her
convenience, and even though I have the folder containg the documents on
the
same cd, the database does not open every pdf. Some work perfectly, some
just
won't open. Is there something I did wrong?

"Douglas J. Steele" wrote:

The best way to do it is not to store them in the database. Store them
externally, and simply store the file information in the database.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"alinoiul" <alinoiul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1237966F-4D1A-4786-8584-89533807FE84@xxxxxxxxxxxxxxxx
Hi!
I am rather new at this and now it seems that I got stuck :)
I am working on a database that requires pdf documents attached to
its
records. Basically the database stores information about some articles,
and I
need to attach a pdf copy of that article to each record.
Which is the best way to do it?
I have tried to add the pdf as linked OLE objects, and everything was
fine
and working well untill I tried to copy the database to a different
computer.
I keep getting various types of errors and most of my pdf.s do not
open.
I would appreciate any suggestion!
thanks





.

Relevant Pages

  • Re: How to add PDFs to Access 2003 database?
    ... The pdfs open or fail to open randomly, and there is no pattern to it. ... don't, such as you've got more than one folder of documents, and all of the ... My boss wants the database on a cd, so she can read the articles at her ... I am working on a database that requires pdf documents attached to ...
    (microsoft.public.access.devtoolkits)
  • Re: Containers, file size and references
    ... Each folder can contain thousands ... itself from an internet site to their cover container field. ... > I'm trying to put files into my FM database, ... > double-clicking it opened the pdf in Adobe Reader. ...
    (comp.databases.filemaker)
  • Re: Design question!, uploading documents to webserver
    ... Storing pdf's in the db doesn't seem to resolve the security issue, since it leaves all access through your web application, and the web application has to handle the security. ... If the app is doing that anyway, you could store the docs in a folder that no user has access to, and let the app provide the docs on request. ... Documents will be in .pdf format. ... Documents will not be stored in database but instead uploaded to a folder on the webserver. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to add PDFs to Access 2003 database?
    ... don't, such as you've got more than one folder of documents, and all of the ... Doug Steele, Microsoft Access MVP ... My boss wants the database on a cd, so she can read the articles at her ... I am working on a database that requires pdf documents attached to ...
    (microsoft.public.access.devtoolkits)
  • Re: Is This Possible ... ? Yes - Upload images to an Access database
    ... It looks like your databases folder is outside the root of your web ... I created a database exactly as you said, the only change I made was to ... and underneath an 'upload' button and a 'view images' button. ... Dim con As New Data.OleDb.OleDbConnection ...
    (microsoft.public.dotnet.framework.aspnet)
Loading