Re: Can Access handle this configuration, or do I need SQL Server?

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 13:00:38 -0500

Take a look at what Albert Kallal has to say about using Access over the WAN
at http://www.attcanada.net/~kallal.msn/Wan/Wans.html 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Paul Ponzelli" <pponzelliREMOVE@ANTISPAMsurewest.net> wrote in message 
news:uQW17MeFFHA.1836@tk2msftngp13.phx.gbl...
> Our organization has four offices networked over 1.55 mb T1 lines.
>
> We have about twenty Access 2002 databases with the front ends in the four 
> offices linked to the back end mdb files in a server at one of the four 
> locations.
>
> Although we have about 50 users in total at the four offices, we seldom, 
> if ever, have more than 5 of them working on any one of these databases at 
> a time, and never as many as 10 at once.
>
> Although improvements and enhancements are never ending, these databases 
> are functional, and they're getting the job done.
>
> Within each office, performance is not a problem; but over the network 
> between offices, things go slow.  Some forms can take 30 seconds to open. 
> I'm planning on improving performance by following the guidelines in 
> Access Help, the MS web site and suggestions from the noble contributors 
> to these newsgroups by doing such things as indexing query criteria fields 
> and the like.
>
> My question is this: Given that we have four locations in the WAN, if I 
> take the proper steps to optimize performance, is Access a feasible RDBMS 
> to use in such a configuration, or do I need to scale up to MSDE or SQL 
> Server?
>
> I realize the Jet engine is only in Maintenance Mode, and I purposely 
> didn't post this question in the SQL Server or MSDE newsgroups, because 
> I'm pretty sure they'll tell me to bite the bullet and upscale now. 
> However, my colleagues and I would have to go through an immediate 
> learning curve, and I'd rather delay that day of reckoning if possible.
>
> Again, if I take the steps to optimize performance of my Access mdb files, 
> should that be workable over the network I've described?
>
> Thanks in advance,
>
> Paul Ponzelli
>

Relevant Pages

  • Re: Cant see (most) shares over the WAN. System Error 53
    ... The browser service works on LAN broadcasts, and these usually are blocked by routers an WAN links. ... If you have a DNS server as a primary at the second site, I would recommend that you also make it a secondary for the other site so that it can resolve the machines in the "other" site for your local machines. ... The master browser in each site can build a browse list of the local network, but you need WINS to allow the master browsers in each site to be able to communicate with each other. ... When I physically go to the remote networkin city B, ...
    (microsoft.public.windows.server.networking)
  • Re: Can Access handle this configuration, or do I need SQL Server?
    ... Take a look at what Albert Kallal has to say about using Access over the WAN ... > offices linked to the back end mdb files in a server at one of the four> locations. ... > Although we have about 50 users in total at the four offices, we seldom,> if ever, have more than 5 of them working on any one of these databases at> a time, and never as many as 10 at once. ... > Again, if I take the steps to optimize performance of my Access mdb files,> should that be workable over the network I've described? ...
    (microsoft.public.access.formscoding)
  • Re: Can Access handle this configuration, or do I need SQL Server?
    ... >> Doug Steele, Microsoft Access MVP ... >>> offices linked to the back end mdb files in a server at one of the four ... have more than 5 of them working on any one of these databases ... performance is not a problem; but over the network ...
    (microsoft.public.access.formscoding)
  • Re: Can Access handle this configuration, or do I need SQL Server?
    ... >> Doug Steele, Microsoft Access MVP ... >>> offices linked to the back end mdb files in a server at one of the four ... have more than 5 of them working on any one of these databases ... performance is not a problem; but over the network ...
    (microsoft.public.access.setupconfig)
  • Re: speeding up the performance of a split database
    ... I regard MS-Access on a WAN as impractical, unless you want to get into ... I do not know how effective SQL Server (ie true ... The back end is on a network server, ... > reports can take a full minute to open, and other operations can take what ...
    (microsoft.public.access.formscoding)
Quantcast