G
Guest
Hi, in a multi-user environment (40 users) spanning across the globe,
(Americas, Far East and Western Europe), is it feasible to have a front end
Access database on each users machine and one data Access database for the
backend and then accessing the data via DAO or ADO, the questions is, which
method will have the better performance in retrieving data record sets.
Some more information has come to hand.
OK there is all ready a database front end and back end, both Access 2000.
For some reason it works everywhere in the world except in parts of Asia. The
front end works when the data database is stored locally but when connecting
the data database over the network to a shared folder (located in the UK) the
front end application apparently hangs. A Ping round trip time for Asia to UK
was 194ms where a ping round trip of 20ms was recorded from Germany to UK. Is
there anyway that this time difference is making the application hang or is
it just slow at updating the front end. There are only four tables linked,
thus I'm not sure even if there would be a difference between using DAO or
ADO for this problem. I expect the problem relates directly to the network
speed. Thus are there any settings within Access or any kind of code that can
be used to force the connection. I suppose many of you that read this will
think a different architecture should be used, yeah your right but there is
no budget for it.
TIA
KM
(Americas, Far East and Western Europe), is it feasible to have a front end
Access database on each users machine and one data Access database for the
backend and then accessing the data via DAO or ADO, the questions is, which
method will have the better performance in retrieving data record sets.
Some more information has come to hand.
OK there is all ready a database front end and back end, both Access 2000.
For some reason it works everywhere in the world except in parts of Asia. The
front end works when the data database is stored locally but when connecting
the data database over the network to a shared folder (located in the UK) the
front end application apparently hangs. A Ping round trip time for Asia to UK
was 194ms where a ping round trip of 20ms was recorded from Germany to UK. Is
there anyway that this time difference is making the application hang or is
it just slow at updating the front end. There are only four tables linked,
thus I'm not sure even if there would be a difference between using DAO or
ADO for this problem. I expect the problem relates directly to the network
speed. Thus are there any settings within Access or any kind of code that can
be used to force the connection. I suppose many of you that read this will
think a different architecture should be used, yeah your right but there is
no budget for it.
TIA
KM