473,589 Members | 2,572 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Speeding Up Access and Jet on a Network



If you have not seen it, this recent Microsoft Knowledge Base article is
worth reading:

http://support.microsoft.com/kb/889588

"How to optimize Office Access and Jet database engine network performance
with Windows 2000-based and Windows XP-based clients"

It is interesting how the 8.3 file format lives on and causes so many
slowdowns. Some fixes are simple registry tweaks. But the article does
explain the general observations that, for Access applications at least,
WinXP has been slower than Win2K, which has been slower than WinNT4.

Here are some of the suggestions for better performance:

Use short 8.3 file names and folder names in the first place. Apparently
Access calls the GetShortPathNam eW API function for each append query when
there is a long file name (why?).

If you have long file names, convert your table links to use equivalent
short names (this latter probably requires enabling short name file
generation in NTFS on the server, which is the default situation).

In Win XP and Win 2K, enable long file name caching on the client machine,
i.e. set InfoCacheLevel to hex 10 (decimal 16) to cache all file names, not
just 8.3 file names. Why this isn't the default?

In Win XP, do not flush each single record individually on append queries,
i.e. on the client computer set DisableFlushOnC leanup to 1. Again, why isn't
this the default?

Connect using a mapped drive instead of a UNC path.

Turn off the file sharing violation notification delay, i.e. set
SharingViolatio nDelay and SharingViolatio nRetries to zero in the registry
for your server machine.

Put the back end on NTFS versus DOS.

Disable short name file generation in NTFS, i.e. set
NtfsDisable8dot 3NameCreation to 1 on the server (not sure how this works
with converting long file name links to equivalent short names on the
client, as suggested above; perhaps no short names improves the call to
GetShortPathNam eW?).

On Win 2003 Server, disable file aliasing, i.e. set NoAliasingOnFil eSystem
to 1 in the registry.


Nov 13 '05 #1
8 3364
Crikey! (or something ruder). Do I have to tell my clients to do all
this to their machines? Fortunately we only use Access in preparing
and analysing the data (only??) and network performance isn't of the
essence here.
David

Nov 13 '05 #2
And I thought tweaking a SQL Server back-end was involved :-)

--
This sig left intentionally blank
Nov 13 '05 #3

"Stephen K. Young" <s k y @ stanleyassociat es . com> wrote in message
news:35******** *****@individua l.net...


If you have not seen it, this recent Microsoft Knowledge Base article is worth reading:

http://support.microsoft.com/kb/889588

"How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients"


Click, whirr/hmmm. Saved.

Lots of good information there.

Apparently, 10 years after the introduction of the long file name,
Microsoft's programmers have yet to discover the usefulness of their
own extension to the O/S.
Nov 13 '05 #4
"Stephen K. Young" <s k y @ stanleyassociat es . com> wrote in
news:35******** *****@individua l.net:
Connect using a mapped drive instead of a UNC path.


This makes absolutely no sense, as mapped drives are resolved to UNC
paths.

Also, mapped drives ARE STUPID USER-HOSTILE HOLDOVERS FROM ANCIENT
DAYS OF DOS.

Maybe a mapped drive is a workaround for the problem of
non-top-level shares. That is, I've long known that putting MDBs in
top-level shares (instead of several directory levels down within a
share) is a big performance improvement.

They don't mention that one.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #5
"Chris2" <ra************ ******@GETRIDOF .luminousrain.c om> wrote in
news:aJ******** ************@co mcast.com:
Apparently, 10 years after the introduction of the long file name,
Microsoft's programmers have yet to discover the usefulness of
their own extension to the O/S.


All I ever needed to know about long file names I learned from
examining the registry entries created by Office 97's installer --
they used the short filenames.

If MS doesn't trust them, then I don't trust them.

I also never use spaces in file names, but that's so I don't have to
worry about typing quotation marks at the command line.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6
> Connect using a mapped drive instead of a UNC path.


O-kay...

Now I would like to know the rationale behind this. Mapped drive are so
troublesome.
Nov 13 '05 #7
"Saintor" <sa******@REMOV ETHIShotmail.co m> wrote in
news:mL******** *************@w eber.videotron. net:
Connect using a mapped drive instead of a UNC path.


O-kay...

Now I would like to know the rationale behind this. Mapped drive
are so troublesome.


Microsoft has been known to post completely incorrect information on
their website.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #8
"Stephen K. Young" <s k y @ stanleyassociat es . com> wrote:
If you have not seen it, this recent Microsoft Knowledge Base article is
worth reading:

http://support.microsoft.com/kb/889588


Also see the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

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
Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
2201
by: Angel Faus | last post by:
Hi all, We've got an Oracle database in a Web application. Intermedia Text queries are an important part of the usage and work fine. The problem is that in order to generate a certain web page, we need to perform a great number of intermedia queries (like 14 o 15). This is part of the bussiness requirements and we cannot change it. So, even if each individual query is not that slow (from 1 to 3 seconds) the accumulation of them is...
10
6029
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network computers cannot access the database. The message is...
9
2868
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly data. I find this tolerable. The Access 2002 test version, on the network, takes approximately 50
0
3281
by: bettervssremoting | last post by:
To view the full article, please visit http://www.BetterVssRemoting.com Better VSS Remote Access Tool including SourceOffSite, SourceAnyWhere and VSS Remoting This article makes a detailed comparison among SourceAnyWhere, SourceOffSite, VSS Remoting and possible others.
5
3098
by: Dave Kolb | last post by:
Is there any other solution for an ASPNET application to access network resources other than running as SYSTEM, using delegation (a nightmare to get to work) or the COM+ solution? I cannot seem to impersonate a user and obtain network credentials using the DuplicateTokenEx call with appropriate parameters even though the call seems to not fail. I check my identity has changed but can only still do local commands. I would consider...
17
4400
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...
10
1301
by: ags5406 | last post by:
I've created an application that downloads data daily from a secure web site and stores that data in an Access database. Then there are different options for allowing the user to do keyword and date searches on the database and have the information displayed for them. Everything looks and functions great, my only real dissatisfaction with my application is the update time, which in my last test took about 45-46 minutes for 9800 records....
1
2605
by: maverickman4 | last post by:
background/setup info: so we have a network set up of about 23 computers including our server which is running windows 2003 standard. we have an incredible amount of traffic going to that server due to every workstation viewing and writing data every few seconds. this is an orthodontic office that is completely paperless. charts and personal info are all on one SQL database on one server. i have pictures to manage and everything. but between...
13
2532
by: evancater | last post by:
My client wants to make their Access 2007 database available to offices around the country with multi-user permissions set to control access to the tables and forms, etc. The easiest thing would be a client/server app, but they are concerned that accessing the backend on their VPN would be too slow. We've discussed the possibility of publishing the forms to the intranet with ASP, but I'm concerned that web development with Access is a...
0
7931
marktang
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...
0
7865
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,...
1
7990
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,...
0
6637
agi2029
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...
1
5731
isladogs
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...
0
5399
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();...
0
3849
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...
1
2374
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
1
1461
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.