Re: upsizing to SQL.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

JohnC wrote:
> Until recently my Access Project was LAN based & ran very well. Now
> the test period is over & the system has been accepted it is
> necessary to run the database over a WAN. There is a dramatic speed
> difference so I'm looking for solutions. I have optimized the project
> & the WAN connection is good but it is still running slowly.
> Apparently my options (without completely re-designing) are either
> some kind of Thin Client server or SQL. Could anybody indicate which
> solution is best & maybe offer some kind of starters checklist! I've
> been using Access for a year but I have no knowledge of SQL at all.
>
> Thank you in advance,
>
> Regards John.

SQL Server only solves the problem of the unreliable WAN connection
corrupting your data (as it would almost certainly do with an MDB back end).
It will not make performance any better. Your performance problems are
caused by how long it takes to pull the data over the WAN connection. Using
SQL Server doesn't magically make that problem go away.

Didn't the "test period" take into account the fact that the fastest WAN is
still 10 to 100 times slower than a pretty crappy LAN and thousands of times
slower than a really good one?

You should either create a web-based front end for the data or look into a
remote (thin client) solution like Terminal Server.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Best Pratice-Remore ADO Access
    ... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
    (microsoft.public.vb.database.ado)
  • Re: upsizing to SQL.
    ... My vote for terminal server....I have a client successfully using this for 2 ... >> & the WAN connection is good but it is still running slowly. ... > SQL Server doesn't magically make that problem go away. ... > still 10 to 100 times slower than a pretty crappy LAN and thousands of ...
    (microsoft.public.access.tablesdbdesign)
  • Re: URGENT !! - Changed over NICs now no LAN
    ... "Dashe" schreef in bericht ... I hav called on LAN ... > Conection and the other WAN conection. ... > Connection but it was currently setup for the WAN Connection. ...
    (microsoft.public.windows.server.sbs)
  • Re: WGR614 router act only as an access point? No seperation of WAN and LAN?
    ... I simply removed the WAN connection. ... plugged the LAN side into my linux gateway and static IP'd ... There isn't any way to do it using the LAN and WAN connections. ... This way, should anyone break the WEP, they'd only get ...
    (comp.os.linux.networking)
  • Re: Best Pratice-Remore ADO Access
    ... and then edit or add new records to it. ... end app will be installed on clients and the SQL Server ... use the Internet to move data back and forth. ... > data over a WAN connection to a SQL Server. ...
    (microsoft.public.vb.database.ado)