Help!

Improving performance over the WAN

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup/Configuration RSS
Next:  Record In Subform Cannot Be Saved - help 2  
Author Message
David Mueller
External


Since: Jul 18, 2006
Posts: 5



PostPosted: Tue Jul 18, 2006 1:57 pm    Post subject: Improving performance over the WAN
Archived from groups: microsoft>public>access>setupconfig (more info?)

First, I do know better but I'm doing it anyway.

Second, without adding any technology (MS SQL, TS, ...) is there anything I
can do to optimize MS Access for use over the WAN? If I can tweak one,
single, solitary, obscure, hardly-ever-heard-of-and-maybe-not-even-published
setting I'll feel better about the whole situation.

Thanks,
David
Back to top
Tony Toews
External


Since: Sep 19, 2003
Posts: 1408



PostPosted: Tue Jul 18, 2006 6:50 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

David Mueller wrote:

>First, I do know better but I'm doing it anyway.

<smile>

>Second, without adding any technology (MS SQL, TS, ...)

Ahhh.....

>is there anything I
>can do to optimize MS Access for use over the WAN? If I can tweak one,
>single, solitary, obscure, hardly-ever-heard-of-and-maybe-not-even-published
>setting I'll feel better about the whole situation.

Put the MDB in the root of the share. Do not put it three folders
down. Also use an eight character or less file name.

That is \\Server\Database\Backend.mdb is preferred to
\\Server\This project folder\that subfolder\yet another
subfolder\Project System backend.mdb.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Back to top
Rick Brandt
External


Since: Sep 30, 2003
Posts: 4254



PostPosted: Tue Jul 18, 2006 9:21 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

David Mueller wrote:
> First, I do know better but I'm doing it anyway.
>
> Second, without adding any technology (MS SQL, TS, ...) is there
> anything I can do to optimize MS Access for use over the WAN? If I
> can tweak one, single, solitary, obscure,
> hardly-ever-heard-of-and-maybe-not-even-published setting I'll feel
> better about the whole situation.
>
> Thanks,
> David

You can make the entire file easy to replace for when it gets trashed.
Otherwise all you can do is make changes such that you are pulling the
absolute least amount of data and writing to disk as infrequently as
possible.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Back to top
Tony Toews
External


Since: Sep 19, 2003
Posts: 1408



PostPosted: Tue Jul 18, 2006 11:11 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

David Mueller wrote:

>Second, without adding any technology (MS SQL, TS, ...) is there anything I
>can do to optimize MS Access for use over the WAN? If I can tweak one,
>single, solitary, obscure, hardly-ever-heard-of-and-maybe-not-even-published
>setting I'll feel better about the whole situation.

Note that you are at a very high risk of corruption. Best wishes.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Back to top
Chris Mills
External


Since: Oct 14, 2003
Posts: 339



PostPosted: Wed Jul 19, 2006 7:06 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Because Access and WAN are so difficult to say in the same sentence, I wonder
who if anyone has actually tried it to any significant extent. Performance is
predictable, I'm not really sure about WAN reliability these days.

So, we need to ENCOURAGE David, better him than me, and hopefully he'll report
back!

<g>
Back to top
Mikal via AccessMonster.c
External


Since: Jan 23, 2006
Posts: 42



PostPosted: Fri Jul 21, 2006 1:20 am    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I don't know what to tell you to do to optimize performance over the WAN, but
I'll give you my own experience. We have about 9MB of data shared among 5
users. I started the DB 3 years ago and had very little knowledge. It shows.
The DB is very far from perfect, but it is useful nonetheless. It is about
150 miles from here to the shared drive and back. Prior to our IT folks
getting the Citrix server stable (there was evidently a learning curve or
else low demand for the service, I don't know which) I could count on finding
a corrupt BE about every month or two. About two or three times a year it
couldn't be repaired and had to be restored from backup files which I try to
remember to make every day. When the network was running smoothly,
performance was slow but acceptable. When the network was marginal, I and my
users wanted to pull out our hair. On the whole, having the shared DB was
better than not having it by a pretty wide margin. Other than that, I only
have two pieces of advice:

1. Agitate for TS or Citrix

2. Make your backups like they vote in Chicago: early and often.

HTH

Mike

David Mueller wrote:
>First, I do know better but I'm doing it anyway.
>
>Second, without adding any technology (MS SQL, TS, ...) is there anything I
>can do to optimize MS Access for use over the WAN? If I can tweak one,
>single, solitary, obscure, hardly-ever-heard-of-and-maybe-not-even-published
>setting I'll feel better about the whole situation.
>
>Thanks,
>David

--
"We have met the enemy and he is us." -- Pogo Possum

Message posted via http://www.accessmonster.com
Back to top
Tony Toews
External


Since: Sep 19, 2003
Posts: 1408



PostPosted: Fri Jul 21, 2006 1:20 am    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Mikal via AccessMonster.com" wrote:

>I don't know what to tell you to do to optimize performance over the WAN, but
>I'll give you my own experience. We have about 9MB of data shared among 5
>users. I started the DB 3 years ago and had very little knowledge. It shows.
>The DB is very far from perfect, but it is useful nonetheless. It is about
>150 miles from here to the shared drive and back. Prior to our IT folks
>getting the Citrix server stable (there was evidently a learning curve or
>else low demand for the service, I don't know which) I could count on finding
>a corrupt BE about every month or two. About two or three times a year it
>couldn't be repaired and had to be restored from backup files which I try to
>remember to make every day. When the network was running smoothly,
>performance was slow but acceptable. When the network was marginal, I and my
>users wanted to pull out our hair. On the whole, having the shared DB was
>better than not having it by a pretty wide margin. Other than that, I only
>have two pieces of advice:
>
>1. Agitate for TS or Citrix

>2. Make your backups like they vote in Chicago: early and often.

Excellent posting. Thanks for that. But you missed one detail.

I thought Chicago also voted from cemeteries?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Back to top
Mikal via AccessMonster.c
External


Since: Jan 23, 2006
Posts: 42



PostPosted: Fri Jul 21, 2006 8:07 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

>Excellent posting. Thanks for that. But you missed one detail.
>
>I thought Chicago also voted from cemeteries?
>
>Tony

Thank you for the compliment. Not being from Chicago, I have only heard the
rumors. I am, however from Louisiana and would like to offer this paraphrase
from former governor Earl K. Long: Do you mean to say you would
disenfranchise the dead? You would actually deny a person's God-given right
to vote just because some P***ant doctor scratched his name on a piece of
paper?!?

Mike

--
"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-setupconfig/200607/1
Back to top
85ascMcLaren
External


Since: Aug 04, 2005
Posts: 17



PostPosted: Thu Oct 15, 2009 12:30 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

If you cannot put the MDB in the root folder, does the same performance
increase come from assigning the root of a mapped letter to the database
location ?

Example: map p: \\xxx\yyy\zzz\abc.mdb

Then relinking the tables based on P:\abc.mdb

???

Jason


"Tony Toews" wrote:

> David Mueller wrote:
>
> >First, I do know better but I'm doing it anyway.
>
> <smile>
>
> >Second, without adding any technology (MS SQL, TS, ...)
>
> Ahhh.....
>
> >is there anything I
> >can do to optimize MS Access for use over the WAN? If I can tweak one,
> >single, solitary, obscure, hardly-ever-heard-of-and-maybe-not-even-published
> >setting I'll feel better about the whole situation.
>
> Put the MDB in the root of the share. Do not put it three folders
> down. Also use an eight character or less file name.
>
> That is \\Server\Database\Backend.mdb is preferred to
> \\Server\This project folder\that subfolder\yet another
> subfolder\Project System backend.mdb.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>
Back to top
Tony Toews [MVP]
External


Since: Jan 30, 2007
Posts: 955



PostPosted: Fri Oct 16, 2009 10:38 pm    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

85ascMcLaren wrote:

>If you cannot put the MDB in the root folder, does the same performance
>increase come from assigning the root of a mapped letter to the database
>location ?
>
>Example: map p: \\xxx\yyy\zzz\abc.mdb
>
>Then relinking the tables based on P:\abc.mdb

I have no idea. That's something I'd have to test.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
Back to top
David W. Fenton
External


Since: Dec 25, 2005
Posts: 1039



PostPosted: Sat Oct 17, 2009 2:10 am    Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

=?Utf-8?B?ODVhc2NNY0xhcmVu?=
wrote in


> If you cannot put the MDB in the root folder, does the same
> performance increase come from assigning the root of a mapped
> letter to the database location ?
>
> Example: map p: \\xxx\yyy\zzz\abc.mdb
>
> Then relinking the tables based on P:\abc.mdb

No. Mapped drive letters are resolved behind the scenes to the UNC
path, so that's not a way to avoid the problem at all. It just hides
it.

Mapped drives are an artifact of the past. Start getting used to not
using them. I stopped using them in 1998,

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup/Configuration All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum