Trying to pass a Table to a VB.Net Class

[Guest]

Hello -

From an Access VBA module, I'm trying to pass a Table to a VB.Net class.

I'm getting the following error running the VBA:

"Unable to cast object of type System._ComObject to type
System.Data.Datatable"

The code resulting in the error looks like the following
In VBA:
Dim mclass As myClass
Set mclass = New myClass

Set mclass.ContractTable = CurrentDb().OpenRecordset("Contract")

In VB.Net:

Public Class myClass

Private myrstContract As Data.DataTable

WriteOnly Property ContractTable() As DataTable
Set(ByVal Value As DataTable)
myrstContract = Value
End Set
End Property

End Class

Suggestions?

Thank you as always,
Mark

 

[stand__sure]

er, let me ask the obvious: why do it this way? you can get to the
table via the OleDbDataAdapter and related objects... it makes sense
to let ADO.NET do the work and not to spend hours trying to shoe-horn
the table into a DataTable object.

http://msdn.microsoft.com/library/d...systemdataoledboledbdataadapterclasstopic.asp