SQL Server 2000 linked tables - slow performance since server transition

Discussion in 'Microsoft Access External Data' started by davenwhoutson@gmail.com, Aug 13, 2007.

  1. Guest

    Hello all,

    Our company uses a frontend Access 2003 system that uses linked tables
    to SQL Server 2000. We recently upgraded to a faster server and
    mirrored the data from the old server to the new server. Ever since,
    the Access program is very slow when opening forms and running
    queries. Is there something that needs to be done to the tables to
    get them to perform as quickly as they used to?

    Thanks,

    David
     
    , Aug 13, 2007
    #1
    1. Advertisements

  2. Jeff Boyce Guest

    David

    We experienced a significant (multi-minute instead of multi-second) response
    time 'hit' after migrating data from an Access back-end to a SQL-Server
    back-end.

    The main contributor(s) were:
    * over-zealous anti-virus software
    * Access (front-end) forms and queries not optimized for SQL-Server
    * back NICs, cables, routers

    Any of these help?

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    <> wrote in message
    news:...
    > Hello all,
    >
    > Our company uses a frontend Access 2003 system that uses linked tables
    > to SQL Server 2000. We recently upgraded to a faster server and
    > mirrored the data from the old server to the new server. Ever since,
    > the Access program is very slow when opening forms and running
    > queries. Is there something that needs to be done to the tables to
    > get them to perform as quickly as they used to?
    >
    > Thanks,
    >
    > David
    >
     
    Jeff Boyce, Aug 13, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. David Rodriguez

    Slow, very slow perfomance wiy\th linked paradox tables

    David Rodriguez, Sep 10, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    445
    GVaught
    Sep 11, 2003
  2. Jason

    Access 2003 linked tables to SQL Server bigint

    Jason, Oct 28, 2003, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    404
    Jason
    Oct 28, 2003
  3. Steve
    Replies:
    1
    Views:
    295
    david epsom dot com dot au
    Nov 26, 2003
  4. Paul Le Sueur
    Replies:
    0
    Views:
    838
    Paul Le Sueur
    Feb 27, 2004
  5. bbitzer

    Linked tables do not show SQL Server Primary key

    bbitzer, May 4, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    341
    Joe Fallon
    May 5, 2004
  6. Guest

    linked sql 2000 tables in access and create table statement

    Guest, Jun 14, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    188
    Guest
    Jun 17, 2004
  7. Darren Brinksneader

    Access 95 Linked Tables with SQL Server 2000

    Darren Brinksneader, Jul 21, 2004, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    320
    Joe Fallon
    Jul 23, 2004
  8. FrankG@fnis

    Linked tables became hidden tables on Server Crash

    FrankG@fnis, Jan 30, 2009, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    316
    Clifford Bass
    Jan 30, 2009
Loading...