I'm experiencing extremely slow response times in design mode of my
forms since moving to Access 2003. Simply dragging a button to a
different position on the form takes 30 seconds or more. The record
source for my form is an ODBC passthrough query to an Oracle database.
I have two XP system identically configured except that one has
Access 2000 and the other with Access 2003. I only have this problem
with Access 2003. The Access 2003 system uses a default file format of
Access 2000.
Not sure what is causing the slowness. Any suggestions would be
appreciated. Thanks. 7 2164 ny****@mr.net (Mike Nygard) wrote: Not sure what is causing the slowness. Any suggestions would be appreciated.
This is certainly worth a look:
<http://members.iinet.n et.au/~allenbrowne/ser-48.html#usabili ty>
Regards,
Keith. www.keithwilby.com
Keith Wilby <ke*********@Aw ayWithYerCrap.c om> wrote in message news:<Xn******* *************** **@10.15.188.42 >... ny****@mr.net (Mike Nygard) wrote:
Not sure what is causing the slowness. Any suggestions would be appreciated.
This is certainly worth a look:
<http://members.iinet.n et.au/~allenbrowne/ser-48.html#usabili ty>
Regards, Keith. www.keithwilby.com
Thanks for you reply. That had a lot of good information in it but
none of it's suggestions seemed to help. When I remove the record
source from the form it seems to work just fine. It's almost like the
passthrough query in my data source is executing each time I make a
change to the form in design mode. Any other suggestions? ny****@mr.net (Mike Nygard) wrote: Thanks for you reply. That had a lot of good information in it but none of it's suggestions seemed to help. When I remove the record source from the form it seems to work just fine. It's almost like the passthrough query in my data source is executing each time I make a change to the form in design mode. Any other suggestions?
That actually could make a lot of sense. I know that there's a significant
difference in performance when editing a form when the FE MDB is linked to BE MDB on
a server vs. locally.
Can you try opening up the passthrough query separately and leaving it open while you
work on the form?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm ny****@mr.net (Mike Nygard) wrote: It's almost like the passthrough query in my data source is executing each time I make a change to the form in design mode. Any other suggestions?
Although when I reread your original posting it doesn't make any sense that there's a
difference between A2000 and A2003.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Mike Nygard wrote: I'm experiencing extremely slow response times in design mode of my forms since moving to Access 2003. Simply dragging a button to a different position on the form takes 30 seconds or more. The record source for my form is an ODBC passthrough query to an Oracle database.
I often had that problem with Access 97 when editing a form bound to a
pass through query. Most pronounced when the query returned a large
number of records and/or when the network was slowed down for whatever
reason.
Other than Oracle SQL tuning (joins coming AFTER criteria, etc), what
has helped me in the past is to take the pass through query and tack on
one or more criteria in the where clause that limit the results to only
a few records that represent what I'm trying to do. After the form was
perfected, I'd drop the special criteria.
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Still no luck. Even though the passthrough query is slow, it is
tolerable in Access 2000 where it only happens once during form
startup. In Access 2000 I can open the form in design mode and it pops
up instantly. Opening the form in design mode In Access 2003
apparently causes the passthrough query to execute. All subsequent
changes in design mode (e.g. moving a button) cause the query to
execute as well. I'm not certain that it is a 2000 vs. 2003 issue.
It seems like there must be some configuration setting that can be
turned on or off to prevent this from happening. The ODBC
configuration is identical between the two machines. I'm using the
Oracle 8 ODBC driver. Anyone else had this problem?
I experiment these kind of trouble while migrating from 97 to 2003.
It appears that some security informations in linked table may cause
some troubles.
If you are using Ms Access security features, try to redefine your
linked tables, that was our solution.
Here you will find some vb code to do that without 150 clicks: http://oraclevsmicrosoft.blogspot.co...able-views-in-
access.html http://oraclevsmicrosoft.blogspot.com
Hope this help.
Thank you for your feed back.
OracleVsMicroso ft ny****@mr.net (Mike Nygard) wrote in message news:<2b******* *************** ****@posting.go ogle.com>... Still no luck. Even though the passthrough query is slow, it is tolerable in Access 2000 where it only happens once during form startup. In Access 2000 I can open the form in design mode and it pops up instantly. Opening the form in design mode In Access 2003 apparently causes the passthrough query to execute. All subsequent changes in design mode (e.g. moving a button) cause the query to execute as well. I'm not certain that it is a 2000 vs. 2003 issue. It seems like there must be some configuration setting that can be turned on or off to prevent this from happening. The ODBC configuration is identical between the two machines. I'm using the Oracle 8 ODBC driver. Anyone else had this problem? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Manuel Lopez |
last post by:
I have a puzzling form timer problem that I didn't experience prior to
Access 2003 (though I'm not sure access 2003 is to blame).
Here's the situation: a computer has two access 2003 databases on it, a
frontend and a backend.
Case 1: If vba code on the frontend updates many rows (360,000) on the
backend, a form's timer event (from the frontend) will stop firing until the
user gives the form focus. (Note that the update itself always...
|
by: dlieu |
last post by:
I've found an odd situation in where the Load event of the active form
fires (after the Unload event) when Access is closed. I am able to
reproduce this situation in Access 2002 SP3 and Access 2003 on
computers running WinXP. This does not appear to happen in Access 2000
on a computer with Win2000.
This only seems to happen if there is a hidden form also loaded and,
so far, I'm only able to reproduce this if the forms are loaded
through...
|
by: Newbillian |
last post by:
I am using Access 2003 and each time I select an object with the mouse
in the report design view, the system hangs for about 5 seconds before
I can move on to another one. It really slows down designing reports
considerably and it didn't used to occur in previous versions. I have
macro security set to low. I have tried uninstalling/reinstalling with
no success. Any ideas? Thanx in advance.
|
by: misseill |
last post by:
Hi there,
I am currently working on converting a program from Access 97 to Access
2003. It all worked fine in 97, but there is some randomness in 2003
that I don't understand. I have a form, Main, that loads as follows in
the code:
1. In Main's Form_Load subroutine, the first line calls a routine
(PutTableOnSubform) that will load a data table's fields onto its
subform's (Template) form.
|
by: TD |
last post by:
This is the code under a command button -
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.BackColor <> RGB(255, 255, 255) Then
ctl.BackColor = RGB(255, 255, 255)
End If
Next ctl
| |
by: BerkshireGuy |
last post by:
I am using Windows 2000 and Access 2003 and noticed that when I click a
control on a report, it takes a few seconds for the "click" to take
place. Its laggy. Same with moving controls, adding new ones, etc.
Any ideas?
Users in my company are reporting slowness in MS Word as well.
We also have Lotus Notes.
|
by: Bobby |
last post by:
Hi,
I have an application which uses Access 2003 as both the FE and the BE.
However, for a number of good reasons, I am in the process of
converting the BE to SQL server 2003. I am not converting the FE to
ADP, I am simply linking the tables using ODBC. I have overcome a
number of isues and it is working quite nicely, however I do have an
issue with a sub form.
I have a main form with two sub forms. I can enter text directly into
the...
|
by: BerkshireGuy |
last post by:
Is there an event that triggers as a form is loading? I want to
display a "loading form" event as the form is loading since it tends to
take 20 second or so to open.
TIA
Brian
|
by: mckbill |
last post by:
Is there a way I can direct the cursor to a specific field (variable)
in a form by typing the field name while in form view?
I have a form with many fields, and it would be nice if there were
some method, similar to FIND RECORD (e.g., CTL + F ), where a dialog
box would pop up and let me enter the field name, and then jump the
cursor to that location.
I currently do my edits by locating a record to be changed by ID using
CTL+F and...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: 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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |