Hi,
I am having really hard time after upsizing from Access 2003 to SQL Server 2008 R2.
I had Access 2003 and database. Previously when I ran Access forms, they were very fast but after upsizing it, it takes 10 times more time to refresh.
- I upsized using upsizing wizard from access 2003 to sql server 2008 r2. I did checked everything like ( table relationship, link tables etc ) while upsizing it.
- So why is this performance issue now after upsizing it. Am I missing something ?
- Do I need to create some odbc etc connection on client machine
- Do I need to again create relationship diagram in sql server database. ( i already had in access and i checked that option to upsize it as well )
- What is causing performance issue ?
Any idea