I run an access query that has been in place here for years.. recently i have been getting an error message that says that the database has reached it's maximum size. Usually, if I reboot and re-run the report, it will work.. however, I am concerned this is just a temporary solution to a bigger...
try creating a view in SQL Query Analyzer... here is an example:
CREATE VIEW dbo.vw_OLAP_dates_lastmonth
AS
SELECT
DISTINCT CS.actual_surgery_date as or_date
FROM
vw_LastDate as MaxDate, Orstat.dbo.orcase as CS
WHERE
CS.actual_surgery_date >= '10/1/1995' AND
CS.actual_surgery_date <...
I am going to answer my own question, just in case someone rund=s into the same problem.... The settings in Acrobat Distiller apparently can be changed by merely opening a .pdf file that has different settings. In other words, even if you have not changed the settings, you should still...
I have a problem with an Access query that prints to a .pdf file. We have been running this query for years, and for some unknown reason the .pdf files are starting to grow in size... They started at around 4KB - 30KB. They are currently coming out around 30KB - 80KB. We have not changed...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.