473,480 Members | 1,914 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to increase the performance by working with linked tables

Dear reader,

To work with linked tables with both mdb's on the same desktop shows an
acceptable performance.

In case the backend mdb with the tables is installed on the network server
and the front-end is located

on the desktop the performance decrees drastically.

Is there any solution to work with an acceptable performance if the
front-end is loaded on a desktop

and the backend is located on a server drive?

Tanks for any help.

Kind regards,

Simon van Beek



Dec 28 '05 #1
1 1381
Simon - take a look at Tony Toews' performance tips at:
http://www.granite.ab.ca/access/performancefaq.htm

-John

"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:43*********************@textreader.nntp.hccne t.nl...
Dear reader,

To work with linked tables with both mdb's on the same desktop shows an
acceptable performance.

In case the backend mdb with the tables is installed on the network server
and the front-end is located

on the desktop the performance decrees drastically.

Is there any solution to work with an acceptable performance if the
front-end is loaded on a desktop

and the backend is located on a server drive?

Tanks for any help.

Kind regards,

Simon van Beek


Dec 28 '05 #2

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

Similar topics

6
6747
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
5
4471
by: Bernie | last post by:
Greetings, I have 3 servers all running SQL Server 2000 - 8.00.818. Lets call them parent, child1, and child 2. On parent, I create a view called item as follows: CREATE view Item as...
3
3060
by: robert | last post by:
consider the following hypothetical (it isn't but....) - start with a COBOL/VSAM codebase that's REALLY old - end with both a COBOL/VSAM and a COBOL/DB2 system which differs in only where the...
5
3982
by: Scott | last post by:
I have a customer that had developed an Access97 application to track their business information. The application grew significantly and they used the Upsizing Wizard to move the tables to SQL...
1
1893
by: S. van Beek | last post by:
Dear reader, How to increase the response in case of working with linked tables, program in frond end mdb and tables in back end mdb. For possible combinations and their response...
2
1844
by: S. van Beek | last post by:
Dear reader, By working with a frond-end and back-end databases with the use of linked tables the performance, if both mdb's are on a local drive is reasonable. But in case the backend is...
1
1933
by: Simon | last post by:
Dear reader, Working with linked tables gives me some troubles. Both mdb's, frond-end and back-end are in deferent folders but on a stand alone pc delivers an reasonable response time say...
3
1519
by: Tony | last post by:
With respect to the questions below, please assume that our database(s) and all text files are shared on a network file server. When opening a shared MDB, what is the effect of its accessing data...
4
7204
by: Jana | last post by:
Hi! I have an Access 97 report based on tables linked to an SQL back end. The report has 5 subreports in it (unfortunately unavoidable due to the nature of the report) and performance is quite...
0
7059
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,...
0
6921
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...
0
7113
jinu1996
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...
1
6767
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...
0
7040
tracyyun
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...
1
4803
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...
0
4506
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...
0
3018
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...
0
1317
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 ...

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.