I split my database into back end and front end, put the back end on
the server, and the front end installed in each PC. How ever, my user
said it is way slower than it was before the splitting. I research
this user group and did what MVPs suggested to have my main form tied
up with a table to keep a consistent connect with the backend table,
but it doesn't seem to help. What else can I do?
Thanks in advance!
Elaine 2 6244
Elaine, work through the list by Tony Toews at: http://www.granite.ab.ca/access/performancefaq.htm
Handle each of those items in turn: subdatasheets, Name AutoCorrect, and so
on.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<El*********@yahoo.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...
>I split my database into back end and front end, put the back end on
the server, and the front end installed in each PC. How ever, my user
said it is way slower than it was before the splitting. I research
this user group and did what MVPs suggested to have my main form tied
up with a table to keep a consistent connect with the backend table,
but it doesn't seem to help. What else can I do?
Thanks in advance!
Elaine
Hi Elaine,
Trying to compact your back end (your data), it will help.
HTH
Yanto El*********@yahoo.com wrote:
I split my database into back end and front end, put the back end on
the server, and the front end installed in each PC. How ever, my user
said it is way slower than it was before the splitting. I research
this user group and did what MVPs suggested to have my main form tied
up with a table to keep a consistent connect with the backend table,
but it doesn't seem to help. What else can I do?
Thanks in advance!
Elaine
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dan V. |
last post by:
We use dot net, asp.net and iis 5 on a pentium 1.2 GHZ (dual capable - one
in now) and 1 MB RAM and Access 2002.
Our ASP.NET Database queries to MS Access (running locally) are very slow,
(the...
|
by: Marc Mones |
last post by:
Hello,
I'working with IBM DB2 V8.1 and CLI/ODBC. I've got a problem with the
following
statement:
********************************************************************************
SELECT...
|
by: ddsvi78 |
last post by:
I am a complete idiot when it comes to access. Now that said, I work
for a computer security company and one of our customers came to us
with an access problem.
They had been running fine for a...
|
by: roiavidan |
last post by:
Hi,
I'm having a bit of a problem with a small application I wrote in C#,
which uses an Access database (mdb file) for storing financial data.
After looking for a similiar topic and failing 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...
|
by: jasmith |
last post by:
How will Access fair in a year? Two years? .... The new version of
Access seems to service non programmers as a wizard interface to
quickly create databases via a fancy wizard. Furthermore, why...
|
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...
|
by: ysh8o1 |
last post by:
Hi,
We upgraded our W2K for a W2K3 server at the beginning of the year.
It's purpose is to handle TS distribution of a couple of MS-ACCESS 97
apps
stored locally on the server.
The server is...
|
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...
|
by: Arno R |
last post by:
Hi all,
So I bought a new laptop 10 days ago to test my apps with Vista. (home premium)
Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1)
So I take the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: 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...
| |