Dear reader,
To work with linked tables is a professional method of working with a frond
end and back end mdb.
Working with linked tables on a local pc gives an acceptable performance but
in case you start working with linked tables on a server (network) the
performance will be drastically reduce.
After moving the tables into the frond end database the performance is
slightly increasing.
Is there any possibility to increase the performance for an application
working with linked tables on a network server?
Tanks for any help.
Kind regards,
Simon van Beek 3 2404
No, it's not possible. Access will always be running on the workstation, not
the server, so placing the links on the server buys you nothing (except
increasing the complication)
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"S. van Beek" <S.******@HCCne t.nl> wrote in message
news:42******** *************@r eader1.nntp.hcc net.nl... Dear reader, To work with linked tables is a professional method of working with a frond end and back end mdb.
Working with linked tables on a local pc gives an acceptable performance but in case you start working with linked tables on a server (network) the performance will be drastically reduce.
After moving the tables into the frond end database the performance is slightly increasing. Is there any possibility to increase the performance for an application working with linked tables on a network server? Tanks for any help. Kind regards,
Simon van Beek
S. van Beek wrote: To work with linked tables is a professional method of working with a frond end and back end mdb.
Working with linked tables on a local pc gives an acceptable performance but in case you start working with linked tables on a server (network) the performance will be drastically reduce.
After moving the tables into the frond end database the performance is slightly increasing.
Is there any possibility to increase the performance for an application working with linked tables on a network server?
I have never found linked tables on a network server to slow down
anything noticeably. I assume you have a poor network and/or an
inefficient application, and/or your expectations are way beyond
Access/Jet capabilities.
As you say, "slightly increasing", I would guess inefficient application
or unreasonable expectations.
There may be other possible reasons, and others may post them.
--
--
Lyle
Often, when you split a database,a nd try it you find that things seem to
run slow.
If you keep a persistent connection open at all times, then I find the
performance is returned to as before.
A persistent connection means that the Front end MUST KEEP a back end table
open AT ALL TIMES!!!
So, in your startup code, have it open a table to the back end, or even a
small form attached to some table in the back end (and then you minimize
this form..and also can make it visible = false.
If you do the above, then you will find that the split performance on the
network will be restored to normal performance.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: infopimp |
last post by:
hi There,
New to ASP, I'm trying to display records from an access qry which
takes data from several tables two of which are linked.
The db which is the source of my qry is on my web server (using IIS),
but the linked tables are on a separate file server on the same
network. However I keep getting an error stating that the db which
contains the linked tables cannot be found. I didn't realise this
would be a problem, thinking that as...
|
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 acceptance see next table:
|
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 located on a network drive the performance is
decreasing drastically.
|
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 good. In case both mdb,s
are stored on a server the response time of the frond-end mdb is faraway
from acceptable. If I import the linked tables in the frond-end mdb on the
|
by: Jim Devenish |
last post by:
I have a split front end/back end system. However I create a number of
local tables to carry out certain operations. There is a tendency for
the front end to bloat so I have set 'compact on close'
I think that I have read in some threads (althoug I cannot find them
now) that others place such tables in a local, linked database. I
could do this but I am interested to know what would be the advantages.
And disadvantages, if any.
Any...
| |
by: a Wellner |
last post by:
I have a Database stored on the server, and a replica on a laptop, used for data collection in the field. The laptop is only connected to the network during synchronization. I am linking to tables in another database, maintained by another agency; the linked tables are used as the source for a lookup field. The data in the table I am linking to changes monthly.
If I have the table linked I get a network error when I attempt to access the...
|
by: BillCo |
last post by:
There seems to be a lot of confusion around the groups about linking
to an Access mdb with the SQL Server Jet OLE DB provider and I havent
been able to find a straight forward solution. Basically, I have an
Access MDB (A2K) on one server and a SQL Server DB (2005 std ed.) on
another - Both on the same network. I'm trying to create a linked
server object in the SQL server to view data in the mdb. I've set it
up and it works - but only from...
|
by: Nathan |
last post by:
Hi,
Got a frustrating problem.
I have sql express, running on a 2k3 server on my network. i have created a
linked server to an access db located on the same server. The tables on the
linked server are setup as Views in an SQL database.
The files for my website are located on the same server as sql server. I
access them from my laptop via a network drive.
|
by: Bret Kuhns |
last post by:
I recently started a co-op/internship at a company and they are
looking to migrate a large legacy supported application from OLEDB to
SQL Server. I'm doing prelim work in experimenting with the options
available. The application is huge (1+ million lines of C++ code), so
it'd be quite a bit of man hours to adapt all the database code for
SQL Server. I stumbled upon linked tables in an OLEDB file to an ODBC
source (such as SQL Server) and...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
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...
|
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |