A very bright Geoff Chappel looked into Microsoft’s claim and said this:

That 32-bit editions of Windows Vista are limited to 4GB is not because of any physical or technical constraint on 32-bit operating systems. The 32-bit editions of Windows Vista all contain code for using physical memory above 4GB. Microsoft just doesn’t license you to use that code.

I say that Geoff Chappel is very bright because he gave a very long and detailed explanation for his conclusion. In fact, there are many very good articles about the Windows Shell in his website.

How does this revelation (that 32 bit Windows can access 4GB RAM and more) affect me ?

I have my reasons to stay 32-bit and I hope that Microsoft will remove the license limit.

Save the following code in a module.

Sub print_query_table_sql()

    Dim s As Worksheet

    Dim qt As QueryTable

    Dim r As Range

    Dim sql As String

    Set s = ActiveSheet

    Set qt = s.QueryTables(1)

    sql = qt.sql

    Set r = s.Cells(1).SpecialCells(xlLastCell).Offset(1, 1)

    r = sql

End Sub

Select your worksheet that contains data from a database source, then run the above macro.

It will print out the SQL in the last cell. (Ctrl-End).

For a while just now, Synergy did not work for me. On the status window, I see these error messages "failed to connect to server: address not found for <my computer name>"

Restarting Synergy on both server and client did not fix the issue.

Finally, I found that the Computer Browser service on the server (<my computer>) was disabled. After I started the service, Synergy worked again.