Working with linked tables on a network server

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

re: Working with linked tables on a network server

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.v.Beek@HCCnet.nl> wrote in message
news:428660b7$0$150$3a628fcd@reader1.nntp.hccnet.n l...[color=blue]
> 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
>
>[/color]

re: Working with linked tables on a network server

S. van Beek wrote:
[color=blue]
> 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?[/color]

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

re: Working with linked tables on a network server

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
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal