Slow form filtering of Access 2000 project when using Access 2002

[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.

 

[Rod Gill]

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/