I have searched for 3 weeks and cannot get a clue on how to deal with my pdf directory. Here is the situation. I created a report with a primary key of an item id....Each item has a pdf that shows the picture of the part (item id). The report opens based on a search criteria of the customer order number....Each order could have 90 lines of orders....hence each line is a different item_id...Each item id is on a new page of the report....The item information is set on the top of the report, on the rest of the 2/3 of the report we want the pdf to print.....I tried inserting an object in the pdf location and that worked well until the database hit 2 gig....apparantly inserting the pdf's as objects took up alot of space even though the pdf's are under 100k each....Alone the pdf folder is 115 megs...,but inside Access as objects they are much more.
I was thinking that SQL would be better to handle the size issue, but when I use blobs or varbinary(max), the pdf doesn't show up as the subreport or image...
Can someone explain to me how I can do this....The environment is using Office XP but saving in 2000 version.
I was thinking that SQL would be better to handle the size issue, but when I use blobs or varbinary(max), the pdf doesn't show up as the subreport or image...
Can someone explain to me how I can do this....The environment is using Office XP but saving in 2000 version.
