Assuming your table names are relatively constant, stick them in a table - tResults with fields tablename text, count integer or long integer, updated datetime. Create a function like

Public...

The class example is currently running in Access VBA. There is very little pruning in it.

Basically we have a query to generate the bitmask for each class. There is link...

Depends what you mean by complex problems. I'm involved in educational admin and we have a standard allocation problem at the start of each academic year.

Each student makes a choice...

Problem is not all errors are trappable.

Look at trappable errors in access vba help to see what is marked as "trappable".

Trouble is you're checking a table not a connection.

I do this as a two parter - first check that I can connect, then check for the table. The basic guts...

We run an Access 2003 app against SQL server 2005. It works very well. In Access 2007 it runs OK. I'm running on a reasonably fast box and don't notice...

Weird.

Correct answer: SQL Server 2005 RTM

Explanation: SQL Server Service Pack 2 or greater is needed to be fully compatible with Windows Vista and Microsoft Office 2007....

Check BOl for the CASE syntax. Try:

SELECT

CASE CurrentSickTerm

WHEN 'LT' THEN 'Long Term'

WHEN 'ST' THEN 'Short Term'

WHEN 'MT' THEN 'Medium Term'

ELSE 'Healthy'

END AS SickTerm

FROM dbo.ViewName

To save repeating myself, have a look at http://www.sqlservercentral.com/Forums/Topic240596-29-5.aspx#bm418021

The syntax of the TOP statement has changed.

We've had similar problems. What I have noticed is that if you search on a non-key field searching is (diabolically) slow. We were searching for a student name in a...

Depends on what you mean by properly. Basically, there is no difference. When I was testing this out, I could switch cleanly between SQL 2000 and SQL 2005(native) and the...

Not only that, if you go the code route you can select the index to use...

Have a look at http://www.mvps.org/access/api/api0049.htm

Great fun. It's not entirely complete you will have to mod the code for your own application but it's very good starting place.

The Access web...

Have a look at http://msdn2.microsoft.com/en-us/library/bb188204.aspx 

To save multiple postings have a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=392573