When our users run reports, they don't always produce the same
results, even though the data has not changed. We have several large
reports containing several subreports. Users can run the report and
the report can have a subreport that shows data. They then run it
again, and the subreport is empty. No error is produced. The problem
is not limited to a specific subreport and can seem to occur
anywhere!?!
We also have instances where forms will display data correctly one
time, and then the next time it can display no data (subsequent
viewings will then show the data correctly again). No error is
produced and the underlying data has not changed.
Our setup is as follows:
* MS Access 2000 Frontend Database using the Access Runtime which is
linked to several SQL Server 7.0 Databases (SP4 installed) on the same
SQL Server. Jet 4.0 Service Pack (SP7) is installed.
* The Frontend application is installed on a Citrix system running on
Windows 2000 SP3.
* All users use the same Access Frontend.
One of my suspicions is that the problem maybe occurring when other
users are running 'heavy' reports at the time, which maybe bogging SQL
Server down at times. Perhaps some soft of time out is occurring,
preventing other queries to not complete. However, I would suspect
some kind of error message.
Alternatively, could it be a problem where users are accessing the
same Access Frontend via several Citrix sessions?
Has anyone seen this type of problem before? Any ideas?
6  1789 
> * All users use the same Access Frontend.
This has been stated here so many times ...
Every user should use his/hers own FE.
--
Hope this helps
Arno R
"Arno R" <ar************ ****@tiscali.nl > wrote in message news:<3f******* *************** @dreader2.news. tiscali.nl>... * All users use the same Access Frontend.
This has been stated here so many times ...
Every user should use his/hers own FE.
Arno,
Thank you for your 'to the point' response. I must admit that I have
spent some time searching through this list, but obviously was not
searching on the right keywords (or problem). Your comment has at
least given me some direction and I will focus on your suggestion as
being the possible cause of our problems. Perhaps if I had the time
to monitor this list more frequently, this would have been obvious to
me. Unfortunately, this is not the case.
Therefore, I have made changes accordingly and will post whether or
not your suggestion has resolved the problem.
Look also at recent thread called:
Split database - Citrix - shared front end question
Arno R
"C Albrecht" <cr************ @fisoftware.co. uk> schreef in bericht
news:96******** *************** ***@posting.goo gle.com... "Arno R" <ar************ ****@tiscali.nl > wrote in message
news:<3f******* *************** @dreader2.news. tiscali.nl>... * All users use the same Access Frontend.
This has been stated here so many times ...
Every user should use his/hers own FE.
Arno,
Thank you for your 'to the point' response. I must admit that I have
spent some time searching through this list, but obviously was not
searching on the right keywords (or problem). Your comment has at
least given me some direction and I will focus on your suggestion as
being the possible cause of our problems. Perhaps if I had the time
to monitor this list more frequently, this would have been obvious to
me. Unfortunately, this is not the case.
Therefore, I have made changes accordingly and will post whether or
not your suggestion has resolved the problem.
Just when I thought that your suggestion had solved my problem, I've
had one of my users report the same issue. All users are now
definately using their own frontends.
I had a user print out a report, and it printed 18 pages, which was
incorrect. She then printed it out again and it came out with 48
pages. I also had another user who did a screen print of a form (Form
with a subform). No data was printed in the subform, although it was
there when she did the screen print. Subsequent screen prints worked
successfully.
The users that have experienced the problems are all using different
HP and/or Minolta printers, so I can't link the problem to a specific
print driver.
Any other thoughts
Thanks
Craig
I also found a reference to KB Q103180 which I'm going to look at further.
cr************@ fisoftware.co.u k (C Albrecht) wrote in message news:<96******* *************** ****@posting.go ogle.com>... I also found a reference to KB Q103180 which I'm going to look at further.
The Problem still happens after following all of the above
suggestions. Any other ideas that people can think of?
Thanks
Craig This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: BStorm |
last post by:
I have a transaction log file where the DataSet table's Description column
is actually delimited into "subcolumns" based upon the transaction id. I
would like to parse these into separate fields for reporting purposes and am
wondering if anyone knows if this is easily accomplished using the .NET
version of Crystal Reports?
For example, the description column may be reporting on a dataentry error as
follows:
TXNCODE: 1010001
|
by: sparks |
last post by:
We have a database that reads in and formats raw data. We were using
queries to format the data per person and outputing reports.
The other database has the persons personal information. I changed the
queries on the raw data to maketables, copied the reports into the
personal info database and they have the reports from the raw data
available for the reports.
NOW they want the reports to be displayed as a new tab in the forms.
I am not...
|
by: Jerry Hull |
last post by:
I'm working with a database developed by an untrained person over
several years - and on a network that has recently been upgraded with
a new server installed and MS office upgraded from 2K (I think - it
might have been XP) to 2003. The database is impressive, both in what
it does and the obtuse and inconsistent ways it works. There are
several hundred queries, for example, with no indication of where they
are used or if they are in fact...
|
by: misscrf |
last post by:
I have a search form that is great. I have modified it in such a way,
that when search results come up I can bring it back to a useful spot,
say an entry form or a report.
Here is my lemon ( hoping someone can help me make lemonade!)
I have this form implemented with my Candidate entry form, as a find.
click the find button, search, subsearch form shows results, click
select on the needed record, and the search form closes, the entry...
|
by: Darryl Kerkeslager |
last post by:
As the subject above hopefully makes clear, I want to do several reports,
"with lots of fields not otherwise in database". These reports also have
variable-length text. I have defined the following options (all users have
Office 2000):
1. All Access solution. This appears to involve creating forms to enter
data that is just put into a report, and never saved - an exercise in wasted
development time, to my thinking. Also, the...
| | |
by: Coy Howe |
last post by:
This one seems bizarre!
We have a database consisting of a main table and 12 - 15 "sub" tables,
which are connected via cascading relationships. The database performs
many complex calculations and displays the results in both forms and
reports. In the process of developing the database we "entered" 12
sample clients. Before packaging the database we remove the sample
clients by deleting them from the main table, which cascades the...
|
by: LP |
last post by:
Hi,
I will be taking on a new project developing a web-based "reporting system".
The first requirement I got from BI group is "we just want to look at the
data". Basically, there is a huge database, and they want certain people to
be able to drill down to the data they want, perhaps a few graphs here and
there, and then extract selected data to an Excel file or a flat file for
further analysis. As of now there are a handful of parameters...
|
by: MattC |
last post by:
Hi,
I am developing a timesheet system that collects information about employees
activities. In this I collect details about projects they do work for, what
type of work, how long, when etc etc.
For distributed data input/storage and display I am happy using ASP.NET.
However ther eis one aspect of the project I am not entirely comfortable
with, report production. The requirement is to produce 6 or 7 reports that
view certain aspects...
|
by: LP |
last post by:
I am using (trying to) CR version XI, cascading parameters feature works it
asks user to enter params. But if page is resubmitted. It prompts for params
again. I did set ReuseParameterValuesOnRefresh="True" in a viewer, but it
still doesn't work. Did anyone run into this problem. What's the solution?
Please help.
Thank you
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
