468,549 Members | 2,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,549 developers. It's quick & easy.

ADP Very Slow in Access 2007



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 ***
Nov 22 '07 #1
1 4859
On Nov 21, 10:29 pm, Ted Kennedy <t...@servicebrands.comwrote:
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.
Nov 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Richard Hollenbeck | last post: by
8 posts views Thread by elias.farah | last post: by
1 post views Thread by PatdeLux | last post: by
39 posts views Thread by cm_gui | last post: by
reply views Thread by zamba | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.