ADP Very Slow in Access 2007

[Ted Kennedy]

I have an Access Data Project (.adp) connecting to a SQL Server 2005
DB over the internet.
The project has been running in Access 2003 for a couple of years,
and performance has been very good.
When I convert it to Access 2007 (maintaining the 2002-2003 file
format) it gets a LOT slower. It takes about 3-5 seconds just to tab to
a new field.
Everything seems to work, it's just as if it is moving in molasses.

Any ideas on what could be causing this?

Thanks very much, Ted

*** Sent via Developersdex http://www.developersdex.com ***

[lyle]

On Nov 21, 10:29 pm, Ted Kennedy <[e-mail]:

I have an Access Data Project (.adp) connecting to a SQL Server 2005
DB over the internet.
The project has been running in Access 2003 for a couple of years,
and performance has been very good.
When I convert it to Access 2007 (maintaining the 2002-2003 file
format) it gets a LOT slower. It takes about 3-5 seconds just to tab to
a new field.
Everything seems to work, it's just as if it is moving in molasses.

Any ideas on what could be causing this?

Thanks very much, Ted

*** Sent via Developersdexhttp://www.developersdex.com***

On Dec 27 2006 I noted:

....

I too have found my ADPs so slow as to be useless in Access 2007.

I haven't tested this solution enough to venture an opinion as to why
or how, but I have found that a newly created (in 2007) ADP operates
just as quickly in 2007 as other ADPs do in 2003. When I import forms
and reports from the old 2003 created ADP to the new 2007 created ADP
they work just as quickly as before.

This has worked for two ADPs here, one connected to a local SQLExpress
Server, and one connected to a remote SQL-2000 server.