L
Leslie
Hi John - I checked that site, thanks. I tried several of
the suggestions without success. FYI.. when I run my
queries & enter the dates directly into the query (from
#11/1/03# - #11/12/03#), the query runs in a minute or
less. When I set the dates up for the user to enter as
variables from a calendar form (from getdate(1) to getdate
(2)), it runs for over 5 minutes, sometimes causing
timeouts with the ODBC connection. In Access 97 on
Windows NT, the calendar form/variables as described above
worked fine. Any suggestions? Thanks very much!!, Leslie
. Reply (E-mail) Forward (E-mail)
Subject: Re: conversion from Access 97
From: "John Nurick" <[email protected]>
Sent: 11/12/2003 2:32:10 PM
Hi Leslie,
Take a look here:
http://www.granite.ab.ca/access/performancefaq.htm
the suggestions without success. FYI.. when I run my
queries & enter the dates directly into the query (from
#11/1/03# - #11/12/03#), the query runs in a minute or
less. When I set the dates up for the user to enter as
variables from a calendar form (from getdate(1) to getdate
(2)), it runs for over 5 minutes, sometimes causing
timeouts with the ODBC connection. In Access 97 on
Windows NT, the calendar form/variables as described above
worked fine. Any suggestions? Thanks very much!!, Leslie
. Reply (E-mail) Forward (E-mail)
Subject: Re: conversion from Access 97
From: "John Nurick" <[email protected]>
Sent: 11/12/2003 2:32:10 PM
Hi Leslie,
Take a look here:
http://www.granite.ab.ca/access/performancefaq.htm