I've split a rather large Access2000 database that resides on a network
drive, by keeping the back-end on the network drive and placing the
front-end on the client's hard drive, linked to it. Both front-end and
back-end dbs are then compacted to save space.
This is a normal procedure, but when I run the database now it performs
much, much slower than the old unsplit version of the database, which is
unacceptable. I have had to back off this to the unsplit version of the
database, but it makes it difficult to install changes to the application
this way. I've never seen anything like this before. There are only 5
clients. All clients have Windows XP-Professional, and are running MS Office
2000.
One other thing, is that I tried putting the front-end on one system that is
running MS Office 2003 (and Access2003), and it works beautifully! Should I
try to have Office2003 installed on all the client machines, or is there
something else going on?
3  1523 
See http://www.granite.ab.ca/access/performancefaq.htm for some things
to check.
On Tue, 19 Jul 2005 17:44:28 -0400, "Bruce Acciavatti" <vi*@gmavt.net>
wrote: I've split a rather large Access2000 database that resides on a network
drive, by keeping the back-end on the network drive and placing the
front-end on the client's hard drive, linked to it. Both front-end and
back-end dbs are then compacted to save space.
This is a normal procedure, but when I run the database now it performs
much, much slower than the old unsplit version of the database, which is
unacceptable. I have had to back off this to the unsplit version of the
database, but it makes it difficult to install changes to the application
this way. I've never seen anything like this before. There are only 5
clients. All clients have Windows XP-Professional, and are running MS Office
2000.
One other thing, is that I tried putting the front-end on one system that is
running MS Office 2003 (and Access2003), and it works beautifully! Should I
try to have Office2003 installed on all the client machines, or is there
something else going on?
********************** ja**************@telusTELUS.net
remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security
Bruce Acciavatti <vi*@gmavt.net> wrote: I've split a rather large Access2000 database that resides on a
network drive, by keeping the back-end on the network drive and
placing the front-end on the client's hard drive, linked to it. Both
front-end and back-end dbs are then compacted to save space.
This is a normal procedure, but when I run the database now it
performs much, much slower than the old unsplit version of the
database, which is unacceptable. I have had to back off this to the
unsplit version of the database, but it makes it difficult to install
changes to the application this way. I've never seen anything like
this before. There are only 5 clients. All clients have Windows
XP-Professional, and are running MS Office 2000.
One other thing, is that I tried putting the front-end on one system
that is running MS Office 2003 (and Access2003), and it works
beautifully! Should I try to have Office2003 installed on all the
client machines, or is there something else going on?
Is the AutoNameCorrect option turned off?
Is SubdatasheetName set to "[None]" for all tables?
--
regards,
Bradley
A Christian Response http://www.pastornet.net.au/response
Thanks for the tips.
I turned off Name AutoCorrect options, and it really sped things up. It's
no big deal living without it, and it's probably better from a developer's
standpoint for tracking object name changes. I like to know what's changed
and try to reasearch that ahead of time anyway, and having it done
automatically makes us lazy.
I'll reset SubdatasheetName for ll tables to "None". Don't need "Auto", as
not using the subdatasheets anyway.
Bruce
"Br@dley" <n0****@4u.com> wrote in message
news:Tm******************@news-server.bigpond.net.au... Bruce Acciavatti <vi*@gmavt.net> wrote: I've split a rather large Access2000 database that resides on a
network drive, by keeping the back-end on the network drive and
placing the front-end on the client's hard drive, linked to it. Both
front-end and back-end dbs are then compacted to save space.
This is a normal procedure, but when I run the database now it
performs much, much slower than the old unsplit version of the
database, which is unacceptable. I have had to back off this to the
unsplit version of the database, but it makes it difficult to install
changes to the application this way. I've never seen anything like
this before. There are only 5 clients. All clients have Windows
XP-Professional, and are running MS Office 2000.
One other thing, is that I tried putting the front-end on one system
that is running MS Office 2003 (and Access2003), and it works
beautifully! Should I try to have Office2003 installed on all the
client machines, or is there something else going on?
Is the AutoNameCorrect option turned off?
Is SubdatasheetName set to "[None]" for all tables?
--
regards,
Bradley
A Christian Response
http://www.pastornet.net.au/response This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Corey Burnett |
last post by:
I have a client that has a split database (front-end/back-end). They
are also using Access security - MDW file. The front end MDE file,
the back end MDB file, and the MDW file are all located on...
|
by: Mario Crevits |
last post by:
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with
Access97 for several years now. We are in an Access97-2000 migration
project. I'm writing a wizard for the end-users to...
|
by: Tardus Merula |
last post by:
We have just put a new samba server on the lab premises and upgradede all
workstations to 100 MB/s, in order to avoid using 10-mile radio link, hoping
that this would enable us to operae our...
|
by: Matt Helm |
last post by:
I am starting the design phase of a large project (ERP) where the
backend will mostly be Python (or Ruby) providing web services.
In this type of usage, is there any benenfit to running under...
|
by: Jeremy S. |
last post by:
We're in the process of writing a new Windows Forms app and the desktop
support folks want for it to be run from a network share. I know it's
possible (i.e., just have the framework on the clients...
|
by: Saurabh |
last post by:
Hi everyone,
I am looking for some expert advise to get me out of trouble. I am looking for a solution in C# which will allow me to split the below string in the format provided. The...
|
by: Mike |
last post by:
Can a vb program running as a serice not use network paths to do file/io?
I can't seem to get my program to work with network paths and files. When I
use local disk it works fine. When I run it...
|
by: funfair |
last post by:
hi,every one
im facing a problem in running access it's about
25 tables
80 forms
46 query (5 append query ,1 update query ,2 delete query )
60 reports
4 modules
after 7 months of perfect...
|
by: olle |
last post by:
How to deal with a VBA-project that is damaged?
Hi everyone.
I am BigOlle from sweden and I have been working with Accees for ten
years
I am now working on a project that started in Access97...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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,...
|
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...
| |
