Guus2005
AWF VIP
- Local time
- Today, 18:41
- Joined
- Jun 26, 2007
- Messages
- 2,641
Hi,
i have an Access 2013 application with a SQL Server 2008 backend.
Customer requested an update and with this new version several tables needed to be updated. Fields added and such. Some indexes where renamed and added
Previous version linked to the tables relativly fast in 4s.
This new version however with a few additions but no new tables linked to the backend in over 2 minutes.
Can you with this limited information give me a hint as to how this can happen?
I was thinking that perhaps indexes needed to be rebuild/reorganized and that over time linking would improve. As of yet that has not happend.
Regards,
Guus
i have an Access 2013 application with a SQL Server 2008 backend.
Customer requested an update and with this new version several tables needed to be updated. Fields added and such. Some indexes where renamed and added
Previous version linked to the tables relativly fast in 4s.
This new version however with a few additions but no new tables linked to the backend in over 2 minutes.
Can you with this limited information give me a hint as to how this can happen?
I was thinking that perhaps indexes needed to be rebuild/reorganized and that over time linking would improve. As of yet that has not happend.
Regards,
Guus