Help with DHTML VB Grid.Datasource

[pcawdron]

Hi,

The following works in VB, but not in VB's DHTML...

Dim WithEvents R As ADODB.Recordset
Dim cn As New ADODB.Connection

Private Sub DHTMLPage_Load()
cn.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Test.mdb"
Set R = New Recordset
R.Open "SELECT * FROM [Test]", cn, adOpenStatic, adLockOptimistic
Set Grid.DataSource = R
End Sub

It loads a datagrid on a form in VB6, but I can't get it to load a datagrid in DHTML. (The ADO Recordset is fine in both)

Can anyone tell me why?

Or, can anyone tell me how I can load a datagrid from a database?

Thanks,
Peter