I overlooked a fairly important detail:  The SQL I gave you for selecting the latest post (either one) will work just fine in an Access query, but the trigger stuff...

If you want to get it all done with one block of SQL, use this:

SELECT

[ThreadID] ,[PostiD] ,[UserID] ,

The careful reader will note that SQL Server is in fact the main repository of the data, and that the move to ASP.NET has begun.

>>In golf, the correct list would be 1, 2, 3, 3, 5.  Nobody came in 4th place, but someone did come in 5th.

>>Robert Lomax

By the way, thanks, Robert.  I...

Used the table of data shown below, in order to provide some rows that pass the tests:

I disagree with the solution.  A list of rankings should not have gaps, which RANK would leave.  You could see a list such as 1, 2, 3, 3,...

I found this at microsoft, but I'm certain that there's another, more common, circumstance under which this can occur. If I find it, I'll post it here.

Meanwhile...

http://support.microsoft.com/default.aspx?scid=kb;en-us;269444

Well...It didn't work for me.  (run as)

When you are running from your home PC across the VPN, the credentials supplied by your PC do not place you inside the domain as a credentialed user. You...

I'd like to ask you about the moment just before you actually open your report. At that moment, do your tables exist, the ones that you need to show...

Are you absolutely certain that you can use this:

ALTER TABLE HumanResources.Employee DISABLE TRIGGER dEmployee

I looked at http://msdn2.microsoft.com/en-us/library/ms176072(SQL.90).aspx#, and the only reference I found to DISABLE was the...

If you're interested in doing DSN-less, here's some code to get you started. Control loops are omitted for clarity.

DoCmd.TransferDatabase acLink, "ODBC Database", strConnectString, acTable, strTableName, strTableName

Here's one possible value...

IMO, you're not likely to get much back against this post. You've put your data and a requirement up, and basically asked the community to do your work for you.

You'll...

Follow jfmccabe's advice. Go for DSN-less. If you're interested in that, here's a little code to get you started:

DoCmd.TransferDatabase acLink, "ODBC Database", _

strConnectString, _

...

I haven't seen any mention of whether you are trying to combine all 100 databases into a single database in SQL Server. Is that your goal?