SQL Reporting Services looks very interesting. Here's a good article and link to Microsoft's site. Although I haven't used it yet, it appears to be very user-friendly and...

Good article. Informative, especially for beginners who are starting to deal with this.

One suggestion: In the second to last paragraph you talk "SQL Server's built-in functionality for optimistic concurrency,"...

Yeah, well sometimes I wonder if these guru guys have jobs or if they just sit around posting all day. 😉

Someone asked about the theory behind XML. I'm not aware of any formal/mathematical theory, but I guess there is one related to the hierarchical, tree-structure of the way the...

Let me start by saying that XML has been overhyped, and MS is guilty of much of that. Since the big XML push of several years back, the first...

Access 2002 uses extended properties in SQL to store meta data about the access application.

Are you using SQL 2000? I don't think SQL 7 had extended properties - not...

There is no Java.NET - Microsoft has released a Java-like language for the .NET platform called J# (J Sharp). It was intended as an upgrade path from their...

This has to do with boolean logic. I took a logic course in a long time ago and I can't remember all the details but basically when you are...

I've never gotten the debugger to work successfully from QA. Good luck to you if you can do it! There's always good ole Print statements... 🙂

However, I have...

To answer you second question first:

Static sql (such as a stored procedure) has a pre-compiled execution plan and thus can be more efficient.

To your first question:

My take on this is...

How well does it work? Also - do you know if the company is legit? (I don't want to install spyware...)

You could accomplish this by using a user-defined function (udf) as the default value. The udf would have to look up the most recently added value for the AccID...

I agree that Flip charts work well. One additional low tech enhancement is to use the flip charts from 3M that are basically giant sticky notes. You can...

Here's a few links that may help. The first one actually compares SQL/MSDE to JET:

http://msdn.microsoft.com/library/en-us/dnmsde/html/msdeforvs.asp?frame=true

http://msdn.microsoft.com/library/en-us/dnmsde/html/usingmsde.asp?frame=true

http://msdn.microsoft.com/library/en-us/dnmsde/html/msderoadmap.asp?frame=true

Just my 2 cents...

I have developed using Access for over 6 years and mostly agree with what has been posted so far.

However I would say that I have...