"Ben" <pillars4@sbcglobal.net> wrote in message
news:PTRPi.1670$LD2.1469@newssvr17.news.prodigy.net...
> We recently upgraded our MS SQL Server 2000 to 2005.
>
> Here is what we did:
>
> 1. Perform backup of the database from the old server.
> 2. Created a blank database in the new server.
> 3. Restored the database into the blank database located in the new
> server.
>
> After this process, there was an obvious slowness in the MS Access
> application. Program-wise, I did not do any code changes. The only thing
> that we did was just this upgrade.
>
> I am leaning towards the netwok causing the slowness. But I do not know
> the issues that might slow down the application just because we upgraded
> the same database into SQL 2005.
>

Ben wrote:

> We recently upgraded our MS SQL Server 2000 to 2005.
>
> Here is what we did:
>
> 1. Perform backup of the database from the old server.
> 2. Created a blank database in the new server.
> 3. Restored the database into the blank database located in the new server.
>
> After this process, there was an obvious slowness in the MS Access
> application. Program-wise, I did not do any code changes. The only thing
> that we did was just this upgrade.
>
> I am leaning towards the netwok causing the slowness. But I do not know the
> issues that might slow down the application just because we upgraded the
> same database into SQL 2005.