UtterAccess.com
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    
 
   
Brandi
post Jan 9 2019, 04:21 PM
Post#1



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".
Thanks.
Brandi
Go to the top of the page
 
theDBguy
post Jan 9 2019, 04:24 PM
Post#2


Access Wiki and Forums Moderator
Posts: 75,326
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
Post#3



Posts: 5,922
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.

hth
tina

--------------------
"the wheel never stops turning"
Go to the top of the page
 
pere_de_chipstic...
post Jan 9 2019, 05:52 PM
Post#4


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


PMFJI

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).

hth

--------------------
Warm regards
Bernie
Go to the top of the page
 
projecttoday
post Jan 9 2019, 07:23 PM
Post#5


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
 
Brandi
post Jan 9 2019, 09:52 PM
Post#6



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
 
stevep
post Jan 11 2019, 06:01 PM
Post#7



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.

https://support.office.com/en-us/article/at...61-7f15baad6dbd

Go to the top of the page
 
Brandi
post Jan 12 2019, 09:21 AM
Post#8



Posts: 1,682
Joined: 24-June 04



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


UA Admin
Posts: 35,016
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
 
Brandi
post Jan 13 2019, 10:12 AM
Post#10



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    25th May 2019 - 02:26 AM