X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Save The Actual Report As An Object In Database?, Access 2013    
post Jan 9 2019, 04:21 PM

Posts: 1,682
Joined: 24-June 04

I'm not sure exactly why but a user has asked if they can save a pdf or other file in the actual access database they are using vs. on their drive or internet somewhere.
In other words, they would run a report in print preview and would like to save that preview in the database without having to run the report again. These are year-end reports that they want to "freeze".
Go to the top of the page
post Jan 9 2019, 04:24 PM

Access Wiki and Forums Moderator
Posts: 75,317
Joined: 19-June 07
From: SunnySandyEggo

Hi Brandi,

What part did you need help with? What have you tried so far?

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
tina t
post Jan 9 2019, 04:38 PM

Posts: 5,921
Joined: 11-November 10
From: SoCal, USA

unless the data itself is subject to change in subsequent years, you should be able to reproduce a report for any given year a day into the next year, or the year after that, or ten years after. if historical records are subject to legitimate change after the fact, i might just copy the year's data - at the end of the year - into an archive table, and run the year-end reports from that table, instead of from the live data table.


"the wheel never stops turning"
Go to the top of the page
post Jan 9 2019, 05:52 PM

UtterAccess Editor
Posts: 10,428
Joined: 8-November 07
From: South coast, England


This does seem an odd request, as Tina states, unless the data is changed, the report can be reproduced at any time in the future.

If the user wants, effectively, to use the database as an index, an alternative may be to save the PDF in a sub-directory of the BE data file folder (or another known directory) and then use Access to open the saved PDF document when required (rather than recreate the report each time).


Warm regards
Go to the top of the page
post Jan 9 2019, 07:23 PM

UtterAccess VIP
Posts: 10,733
Joined: 10-February 04
From: South Charleston, WV

The usual way is Docmd.OutputTo.

Robert Crouser
Go to the top of the page
post Jan 9 2019, 09:52 PM

Posts: 1,682
Joined: 24-June 04

I agree with you all. I'm just going to tell them to simply run the report whenever they want. It is based on a begin date and an end date so they can run it for whatever period they want and the data should not change.
Or they can save as a pdf to some location on their server.

Thank you. Brandi
Go to the top of the page
post Jan 11 2019, 06:01 PM

Posts: 84
Joined: 9-November 14

There were some interesting links if you google Access Attachments.

Beware, including documents right in the database will increase the size of it. If you go this route, I would create a separate database for this purpose.


Go to the top of the page
post Jan 12 2019, 09:21 AM

Posts: 1,682
Joined: 24-June 04

Thanks. I'll check it out.
Go to the top of the page
post Jan 12 2019, 09:50 AM

UA Admin
Posts: 35,013
Joined: 20-June 02
From: Newcastle, WA

Just a question:

How does storing a PDF internally, as an attachment, compare to storing the same PDF externally, on a file share?

What are the (proposed) advantages of doing that? Disadvantages?

While there are some known negative impacts, i.e. bloat of the accdb file, it's not obvious what positive aspects your users might be looking at.

My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
post Jan 13 2019, 10:12 AM

Posts: 1,682
Joined: 24-June 04

I totally agree. Just an odd user but I have convinced them to just store it as they normally would any file or document on their computer or server.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    24th May 2019 - 07:02 AM