L
Leslie Brookins
Good morning all - I am converting several databases from
Access 97 to Access 2000. The smaller databases are
working fine. However, I have a number of large databases
that I have converted - queries on large tables in these
databases are running very, very slowly since the
conversion. These databases are connected to tables on an
SQL server using ODBC. I use a calendar form so that the
user can select dates - these are assiged to a VBA
variable... These queries worked fine in Access 97 -
maybe Access 2000 is handling the variables differently?
The queries are so slow that often they are timing out
before completing. I saw in the Microsoft Knowledge base
that queries are sometimes slower in Jet service pack 4 or
5 but we are on service pack 7 so that should not be our
problem. Any advice? Thanks!!!!, Leslie
Access 97 to Access 2000. The smaller databases are
working fine. However, I have a number of large databases
that I have converted - queries on large tables in these
databases are running very, very slowly since the
conversion. These databases are connected to tables on an
SQL server using ODBC. I use a calendar form so that the
user can select dates - these are assiged to a VBA
variable... These queries worked fine in Access 97 -
maybe Access 2000 is handling the variables differently?
The queries are so slow that often they are timing out
before completing. I saw in the Microsoft Knowledge base
that queries are sometimes slower in Jet service pack 4 or
5 but we are on service pack 7 so that should not be our
problem. Any advice? Thanks!!!!, Leslie