Iordan,

Ah! That may be what I heard about Access 2003 vis-à-vis SQL Server 2005...that the Access visual query builder can't be used. It certainly does save a lot...

Wayne, JJ B, and jfmccabe,

Thank you all for your replies. That is very good news. I can't say where I heard about the problems I mentioned. Must...

Wayne,

Very nice points about Access reporting.

I wonder if you could answer a question for me: Do you know if Access 2003 connects with SQL Server 2005 properly? I...

Sam,

Thank you for pointing that out. Your post and Steve's make the possibilities open up for me considerably.

Regards,

Steve,

» Hope this makes sense. «

Yes, it does! That's actually very exciting! I knew that that sort of ownership existed, but I was under the misapprehension that it...

Steve,

I appreciate the input. You are no doubt correct about protecting myself by setting up separate databases. I'm sure it would work; I'm just concerned about simplicity of...

Looks like this idea is reasonable and workable and all that? Just looking for a caveat or two.

Regards,

Dear Andy, Brian, and Steve,

Excellent news! This is one of the best technical sites on the web and it sounds like you fellas have made a terrific move to...

Nostalgia is good stalgia! I did useful, problem-solving things on a Singer/Friden 1152 RPN programmable calculator in 1969 as a high school senior in statistics class...but that only had...

Kenneth,

I got this from Wikipedia:

"Members of other cultures often find it unusual that Icelanders formally address others by their first name. For example, current prime minister Halldór Ásgrímsson would not...

Kenneth,

Sorry about that passing reference. Your name looked very Icelandic to me and so I took a flyer. My experience with/knowledge of Scandinavian countries extends mostly to Iceland...

Amit,

That doesn't quite do the trick either, I'm afraid. It joins the two "lookup" tables to the many-to-many table, StudentCourse, but it makes no provision for selecting only those...

Kenneth,

Thank you very much. A nice discussion of the problem. I found one of Joe's posts that describes things in a similar way.

Regards,

Joe,

That's IT! You know, I even checked out your second edition of "SQL for Smarties" from the library not long ago, but I forgot all about relational division.

In looking...

Paul,

Hmmm...that query doesn't quite do the trick. If the student takes both courses, the subquery produces a separate row for each course, with the 1/0 flags set separately. ...