Hi there,
We have an Access 97 application (client install on workstation PCs) that used to have it's Database backend hosted on a NetWare server. No real problems but it was decided to move it to a Windows based server. we have tried a Windows 2003 server and a Virtual Server and have found performance to be severley impacted on the client PCs. Cannot quite understand why. The clients are Windows 2000 SP4 or Windows XP SP2 with Novell Client 4.91 SP2 and probably Office 2000 or 2003 installed.
Anyone have any ideas?
Cheers
Keith
4  1449  Denburt 1,356
Recognized Expert Top Contributor
Hmmm, well first have you compacted both front and back ends? Second question is this running across a LAN or WAN?
Denburt 1,356
Recognized Expert Top Contributor
A couple more things just hit me. Are the links from the clients machine to the backend utilizing a mapped drive or direct path? Mapped is somewhat quicker, Microsoft also recommends using short file names when linked to a backend.
A couple more things just hit me. Are the links from the clients machine to the backend utilizing a mapped drive or direct path? Mapped is somewhat quicker, Microsoft also recommends using short file names when linked to a backend.
Thanks Denbert, will check that out. I think it is mapped drives. The application is unfortunately compiled so we can't determine if the Db is split or not. I think that the naming is short filenames but againwill check. Also, it is running across a LAN (100MB to the desktop 1GB core).
Denburt 1,356
Recognized Expert Top Contributor
Well there is so much more that can be added but I think it's best if you look this over then let me know what you think or if you have more questions/issues. http://support.microsoft.com/kb/889588 Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: WalterR |
last post by:
This is my first time here, so there may be earlier relevant threads of
which I am unaware. Though my experience with DB2 is not extensive,
such as it is was under OS/390 or equ. My main experience is IMS DB,
which leads to my question.
In IMS, there is an HDAM access method which can find a record without
using an index as such. At...
|
by: Terry Bell |
last post by:
We've had a very large A97 app running fine for the last seven years.
I've just converted to SQL Server backend, which is being tested, but
meanwhile the JET based version, running under terminal server, has
suddenly started running very slowly. The network engineer has thrown
up his hands and said "It's Access 97". I've checked out lots of...
|
by: Tony Lee |
last post by:
Some time a ago, on this newsgroup the following comments were made in
recommending
good references for Access (2003)
>I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for
>people moving from power user to developer, but now I suggest you browse
>it,
>too. It strongly emphasizes ADO, which knowledgeable Microsoft...
|
by: Bob Alston |
last post by:
Most of my Access database implementations have been fairly small in
terms of data volume and number of concurrent users. So far I haven't
had performance issues to worry about. <knock on wood>
But I am curious about what techniques those of you who have done higher
volume access implementations use to ensure high performance of the...
|
by: lgbjr |
last post by:
Hello All,
I've been developing a VB.NET app that requires the use of a DB. Up to now,
I've been using Access. It's a bit slow, but everything works. I'm at a
point now where I need to decide if I should stay with Access or move the DB
to SQL. I'm trying to come up with a list of Pros/Cons for such a move. My
list is a bit lopsided, as I...
| | |
by: DaveG |
last post by:
Hi all
I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.
The delema is what is best to...
|
by: egoldthwait |
last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a
Citrix farm. The issue: we have never converted an Access Db to Oracle
but can probably use Oracle's Workbench to assist with this. Also - the
citrix folks do not want us to keep the FE in Access as the queries and
other activities consume a lot of power. The users will be in...
|
by: onnodb |
last post by:
Hi all,
While working on an Access UI to a MySQL database (which should be a
reasonable, low-cost, flexible interface to the DB, better than
web-based, much less costly than a full-fledged .NET app or so.... is
it?), I tried measuring the bandwith consumed by the
Access/MyODBC/MySQL link, which came out to be, er, quite high.
I fancied...
|
by: dorpnospam |
last post by:
We have an old but very critical application that was written in VB 6
against Access 95 dbs. We need to ditch this decrepit old unstable db
platform but we are trying to determine the best migration path to SQL
Server.
I am researching options. I started by upgrading a sample db to Access
2003 and update the VB 6 app to use DAO 3.6. That...
|
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...
|
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...
| | |
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. ...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
