Joins aren't the problem, Robert. There are other restrictions, though. You
don't seem to be able to use an ORDER BY clause in a view. I tried using
SELECT TOP 100 PERCENT, which I understand is what you have to do to use
ORDER BY in a SQL Server view, but that doesn't seem to work in JET. You can
still use an ORDER BY clause, though, you just have to create a procedure
rather than a view ...

Module Module1

   Sub Main()

       Dim strCnn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\usenet\db1.mdb;" & _
           "Persist Security Info=False;" & _
           "Jet OLEDB:Database Password=password"
       Dim cnn As New System.Data.OleDb.OleDbConnection(strCnn)
       Dim cmd As System.Data.OleDb.OleDbCommand
       Try
           cnn.Open()
           cmd = New System.Data.OleDb.OleDbCommand
           cmd.Connection = cnn
           cmd.CommandText = "DROP VIEW vTest"
           cmd.ExecuteNonQuery()
           cmd.CommandText = "DROP PROCEDURE pTest"
           cmd.ExecuteNonQuery()
           cmd.CommandText = _
               "CREATE VIEW vTest AS SELECT " & _
               "Customers.CustomerID, " & _
               "Orders.OrderID FROM Customers INNER JOIN Orders ON " & _
               "Customers.CustomerID = Orders.CustomerID"
           cmd.ExecuteNonQuery()
           Console.WriteLine("View created")
           Console.ReadLine()
           cmd.CommandText = _
               "CREATE PROCEDURE pTest AS SELECT " & _
               "Customers.CustomerID, " & _
               "Orders.OrderID FROM Customers INNER JOIN Orders ON " & _
               "Customers.CustomerID = Orders.CustomerID " & _
               "ORDER BY Customers.CustomerID DESC"
           cmd.ExecuteNonQuery()
           Console.WriteLine("Procedure created")
           Console.ReadLine()
       Catch ex As Exception
           Console.WriteLine(ex.Message)
           Console.ReadLine()
       Finally
           If Not cnn Is Nothing Then
               If cnn.State <> ConnectionState.Closed Then
                   cnn.Close()
               End If
           End If
       End Try
   End Sub

End Module