Re: Improving performance over the WAN

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

David Mueller <DavidMueller@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
.

Relevant Pages

  • Re: Improving performance over the WAN
    ... David Mueller wrote: ... can do to optimize MS Access for use over the WAN? ... If I can tweak one, ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: "FE Updater" and macro security
    ... Then it goes down the registry keys from newest version to oldest looking ... So if you had A2000 and A2003 installed with an A2000 MDB/MDE it ... Tony Toews, Microsoft Access MVP ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (comp.databases.ms-access)
  • Re: MS Access Front End - SQL Server Backend
    ... I had no idea how linked SQL Server tables over a WAN ... There are lots of folks using Access against a SQL Server backend. ... occasional user freeze up while submitting this information. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sooooooooo Slooooooow
    ... connecting over a WAN. ... It's too "chatty" for WANs unless the WAN ... Or just plain Terminal Server will do although Citrix adds some benefits such as ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: odbc connection vs. linking
    ... Using Access for the data storage on a LAN ... I mean WAN, WAN not LAN. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)