Dear All
We have a SQL Server 2000 BE on a Win 2K Server box. Access 2000
clients, running on Win 2000 Pro.
Front end design is fairly straight forward - 5 different "record
types" (split across approx 20 tables). For each "record type", there
is a datasheet view, listing the records of that type, and this can be
filtered by using a combination of text / combo / check box filters
above the subform datasheet. On clicking a record ID in the datasheet,
the "main form view" appears, listing the full details for the chosen
record.
Lately, the forms have become incredibly slow to display - not just a
problem populating the datasheets, but even to draw the comboboxes
takes time. The main form views are also very slow.
Curiously, if I take the SELECT statement from the datasheet
recordsource property, and paste it as a query within Access on my
machine (still linked to the SQL BE), the query returns almost
instantly (blink and miss it sort of speeds!). This suggest of course
that there are no network problems, and that Access is getting things
wrong. This is kinda emphasized by opening the subform on its own (as
opposed to within the parent form as part of the running app) - and
here the same problem occurs. However...
Running the client Access app on the server itself, and everything is
high speed... suggesting Access is fine, and there are network
problems!
Please help me. Im getting kinda dizzy chasing my tail so much!
TIA
Steve
2  1766 
Steve,
I think I've had a similar problem before. Everything seemed to be
working fine, but loading of forms and everything was really slow.
What I ended up having to do was create a new Access database and
import in all the data from the other database. You'll probably have
to relink objects as well. You can save the new database with the
same name as the old one once the old version is deleted. It's worth
a try.
Kara www.klh-tech.com
KLH Technology Solutions ka********@hotm ail.com (Kara Hooper) wrote in message news:<dc******* *************** ****@posting.go ogle.com>... Steve,
I think I've had a similar problem before. Everything seemed to be
working fine, but loading of forms and everything was really slow.
What I ended up having to do was create a new Access database and
import in all the data from the other database. You'll probably have
to relink objects as well. You can save the new database with the
same name as the old one once the old version is deleted. It's worth
a try.
Kara
www.klh-tech.com
KLH Technology Solutions
Hi Kara,
Thanks for your thoughts. I fear you may well be right too! Oh well,
it'll keep me busy for a bit!
Meanwhile, any more thoughts from any other folks?
Cheers
Steve This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Neil |
last post by:
I previously posted re. this, but thought I'd try again with a summary of
facts.
I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that
is linked to the database via ODBC and has been in place for several years
without any performance problems.
Recently I added a couple of fields to the output of the view, and it became
very slow when scrolling. When just opened in the database window, the
linked view takes about...
|
by: Phil |
last post by:
I would like to open up an open mdb residing on a remote computer in
order to view data. I would prefer that the orig mdb stay exclusive or
at least some form of shared as read-only.
I keep getting 'not allowed' error message. I've tried attaching the
tables to an mdb on my computer but same lock comes up.
What do I need to access those tables for viewing and read-only access.
|
by: Hernán Freschi |
last post by:
Hi all, I'm a completely newbie here. I'm having a problem. I've
programmed before in VB6 and such, and all the programs I've made run
fast. But .NET programs run very slowly. I use C# (for no particular
reason).
It's not the algorithms (that is, what the program * does *, that works
fine), but the UI responsiveness. This programs "hides" in the traybar
and sits there until the phone rings (It's a Caller ID program).
Everything works...
|
by: Drwtsn32 |
last post by:
Hi Guys,
I'm ripping off all of my hair soon ;-)
I'm trying to do a very simple C# form accessible from COM client like
VBScript.
I would like to display the form and update the form during the
intepretation of the vbscript. Does anyone know of any good example that
could point me to the right direction.
|
by: Ant |
last post by:
Hi,
I'm using the text changed event of as text box to display a datagrid of
search results dynamically. (The classic 'gets more specific the more you
type in' scenario ).
I find when I first start the app & type in something into the text box, it
stalls & won't display the text you've typed in. After a short while, the
text appears & the results are loaded into the data grid. After the first
time, it works perfectly; loading data in as...
| | |
by: Andy_Khosravi |
last post by:
I'm having a problem trying to optimize the performance of one of my
A97 databases. I have very slow record navigation after a change I made
to the table structure, and I'm not sure how best to correct it.
For purposes of explanation, lets say I have two tables: tblIssues and
tblLocationHistory. The tblIssues table contains 'incidents' along with
the incident header information. The tblLocationHistory table contains
a list of all...
|
by: jimatqsi |
last post by:
I'm using Access 2000 (and also 2003 with same result) in a Windows XP Professional environment on a peer-to-peer network. Files in this system are relatively small. There are about 1,200 rows in the item/warehouse table, about 200 order headers, and about 2000 order detail rows.
I have a form with a sub-form in the detail of the main form. The sub-form is a continuous line display (not single item); In the heading I am getting a customer's...
|
by: Michael |
last post by:
I work with a highly programmed Access
database (some 15,000 lines of VBA code, much of it automating data
entry on forms -- and believe me, it's very tight code). In Access
97,
2000, 2002, and 2003, no performance problems. However, when I open
the same database in Access 2007, it's as slow as molasses. Data
trickles onto the form instead of an immediate display in Access
2003.
This happens regardless of whether I keep the Access...
|
by: eighthman11 |
last post by:
using Access 2003 and sql server version 8.0
Hey everyone. Created a text box where the user types in an Inventory
number and it takes them to that inventory number on the contimuous
form. The form is based on a link table to sql server. Here is the
code:
Dim rst As DAO.Recordset
Dim InventoryItem As String
InventoryItem = "'" & "TextBoxValue" & "'"
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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.
| | |
