At this stage in my learning experience, i have just now got comfortable querrying using sql2000, before it was only in the vb.net enviroment. Everything just seemed so overwhelming to me in the em so i stuck with the vb.net to handle the querrys. Now that i see just how powerful the em is i am keeping all of my foucs on the em and analyezer. (Since i am teaching myself you would not believe the steps i use to take for what seem simple task now).I AM not comfortable with the Analyezer yet. I am under the belief that the Analyzer is for more well seasoned (pros) database developers. Its just to much for me at this point. However, i do like to desinger the querry and them skip over to the analyzer to see the results.

I have never worked with access, however, my understanding about access is that it is a good LOCAL database for small companys or just small solutions?

Erik..