Slow form filtering of Access 2000 project when using Access 2002

  • Thread starter Thread starter Teresa Plott
  • Start date Start date
T

Teresa Plott

I recently converted an Access 2000 database to an Access
2000 project that connects to a SQL Server 2000 database.

I just installed the application at my client and found
that the Access 2000 project works great when running with
Access 2000 on a computer running Windows 2000 or XP.

However, on their older computers which are running Access
2000 on Windows 98, the computers hang after opening and
closing a few of the Access project forms (only option is
to press Cntl-Alt-Delete and reboot the computer).

Also, on their newer computers which are running Windows
XP with Office XP/2002, the form filters that I have
implemented on a couple of forms take 10 to 20 times as
long to run as on a computer running Access 2000. (I am
using the Filter property to set my form filters.) For
instance, using Access 2000, setting the Filter property
to run a single SQL Server record based on the primary ID
takes 1 to 2 seconds. However, using Access XP/2002, this
can take up to a minute.

Does anybody know what is causing these flaky behaviors?
Any help would be most appreciated.
 
Hi,

I've found that instead of applying filters in .adp's it's better and more
reliable to rebuild and submit the SQL string for the recordsource.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 
Back
Top