query does not work on 2008 server

[maker2254]

I purchased a 64 bit server which has 16 gb memory 2 dual core cpu .
I am trying to moove everything from 2003 server to 2008 server .But i have a big problem . I have a ms access (2003) query which perfectly works on 2003 server machine. I copy the same mdb file or mde file into 2008 server that i mentioned the properties above. the query gets stuck and consumes the resources.It returns the result but very late. Have you guys had the same experience before. Please help. Any input would be appreciated.Thanks in advance

 

[kjv1611]

This may be more of a Windows Server question than an MS Office question. Have you tried in that area?

forum1674

forum931

http://www.tek-tips.com/forumsearch.cfm?SearchString=windows+server&type=Forum&sub=Search

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

One other possible thought: Are you running the same version of Office on the 2008 server as the 2003 server? Also, did anything else change at all? Could it also be that the underlying tables of the query are just much larger now from use over time?

--

"If to err is human, then I must be some kind of human!" -Me

 

[maker2254]

Thanks for the reply. I have office 2003 in both server . Nothing changed as a matterfact i copy the application that works on 2003 server and put it into 2008 . Everything is same other than the outcome

Thanks for the links I will try.

 

[kjv1611]

Yeah, it's most likely the difference from 03 to 08, then.

--

"If to err is human, then I must be some kind of human!" -Me