(Msg. 9) Posted: Thu Oct 15, 2009 8:30 am
Post subject: Re: Improving performance over the WAN [Login to view extended thread Info.] Archived from groups: microsoft>public>access>setupconfig (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 <DavidMueller.RemoveThis@discussions.microsoft.com> 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 >
(Msg. 10) Posted: Fri Oct 16, 2009 6:38 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
I have no idea. That's something I'd have to test.
(Msg. 11) Posted: Fri Oct 16, 2009 10:05 pm
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?=
<85ascMcLaren.RemoveThis@discussions.microsoft.com> wrote in
news:9895D4A4-550A-4A8A-8EAB-11F4939ABA37@microsoft.com:
> 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,
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
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
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other