Re: Access 2003 to SQL Server 2000 over a VPN
- From: "Neil" <nospam@xxxxxxxxxx>
- Date: Fri, 13 Jul 2007 23:55:02 GMT
I don't know about performance with ADPs; but I have an MDB (with an MDB
back end) that's in A2000 format, and has been running great in A00 and
A02/03. Running it in A07, everything seems slower. Droping down a combo box
with a couple hundred items takes a few seconds (instead of instantaneous,
previously). Clicking on various tabs in a tab control results in a delay of
a second or two per click (again, instead of instantaneous). So, A07, in
general, seems to have some problems with performance, whether ADP or MDB.
Neil
"Robert Morley" <rmorley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eia5bDBuHHA.5072@xxxxxxxxxxxxxxxxxxxxxxx
On a related note, I have no experience with A2007 myself, but I seem to
remember hearing that the patch didn't entirely address the sluggishness
of A2007 when opening ADP's...that it was "better", but not "fixed". Can
you confirm whether or not that's still an issue, just so I know what to
tell people? Thanks!
Rob
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:O6e3K9AuHHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
This is the aforementionned patch:
http://support.microsoft.com/kb/936519/en-us
However, I don't know personnally if it works properly.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Robert Morley" <rmorley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eCmIKSAuHHA.1052@xxxxxxxxxxxxxxxxxxxxxxx
Hi Aaron, bye Aaron.
(For those who may not have come across Aaron before, he is a very
abusive troll in the Access newsgroups whose entire purpose in life is
to get everybody to use ADP/SQL Server for absolutely everything from
one-person databases to international databases to dating to washing the
dishes. He has recently discovered the joys of changing his address in
order to get around the blocks Microsoft has placed on him, and
frequently impersonates Access MVPs in the hopes of adding credibility
to his abusive ravings.)
Rob
"Tom Wimpernads" <tw@xxxxxxxxxxx> wrote in message
news:O6r9%23W9tHHA.736@xxxxxxxxxxxxxxxxxxxxxxx
Robert;
where did you come up with this crap, bitch?
MS just came out with a patch for ADP a few months ago
"Robert Morley" <rmorley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OUvd0P3tHHA.3468@xxxxxxxxxxxxxxxxxxxxxxx
With a moderately well-designed database, VPN should be quite
feasible.
The simpler the database, the easier it will be to set up in this kind
of
environment. I would recommend looking at the possibility of using an
ADP, rather than an MDB, but there's the distinct disadvantage that
ADP
may not be well-supported in the future. Microsoft has not clearly
commented on their direction with ADP's. (There's also a bug in
Access
2007 that causes tremendous slowness for ADP's, though it doesn't
occur
in earlier versions.)
To give you an idea, I'm using a fairly complex database using and ADP
as
the front end over a VPN connection. Since I work from home, I use it
every single day. The VPN speed is nominally 3M/800k, though we have
bad
lines in our area, so typically get about 2M/500k. The design of the
database was not well-written for a client-server model, since that's
not
how it started its life, though it's been tweaked to be at least
somewhat
better. Nevertheless, I find the speed quite acceptable for most of
the
work that I do.
A *very* simple, *very* well-designed client/server database could
conceivably even be used over a slow connection like a modem, but as a
rule, I wouldn't want to try it.
Rob
"James Franklin" <jimbo.jetset@xxxxxxxxxxxx> wrote in message
news:5qSfi.6657$_l6.2897@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have a client who has a simple Access database, which he now
requires
to be accessible to up to 50 concurrent users remotely over the
internet, as well as a small number of local LAN users.
I am looking at a solution whereby the data is stored in a SQL server
database, with front-end Access mdb's on each machine, connecting via
ODBC, either directly over the LAN or over a VPN for the remote
users.
The client will either have an ADSL or SDSL broadband connection to
the
server through a managed firewall.
Can anyone tell me if this is feasible, and if so, what connection
speeds would be required to support this number of users? Although
the
worst case scenario is 50 concurrent users, the likelihood is that
there
would never be more than about 15 connected at the same time.
Any help is greatly appreciated!
Jim
.
- Prev by Date: Re: Access project needs to close error
- Next by Date: Re: Access 2003 to SQL Server 2000 over a VPN
- Previous by thread: Re: Access 2003 to SQL Server 2000 over a VPN
- Next by thread: Re: Access 2003 to SQL Server 2000 over a VPN
- Index(es):
Relevant Pages
|
