user defined type not defined

[Guest]

I'm trying to convert my first ACCESS 97 project to Access 2003. I'm
receiving the above error when I try to compile a module. It stops on the
following:

Private Function CreateQueryResultTable(rsSource As Recordset, TargetTable
As String, ResultCols As Integer) As String

I think the bigger question is, "Does a paper exist that identifies the
differences between Access 97 and Access 2003 or likewise, VBA with VB.NET?"

I'm new at this and I'm thinking it is Recordset that is actually the issue.
I have seen reference to ADODB.Recordset, but chaning it to that does not
make a difference.

 

[Guest]

More than likely you are using a DAO method ...
Change it to:

Private Function CreateQueryResultTable(rsSource As DAO.Recordset,
TargetTable
As String, ResultCols As Integer) As String

Also .. make sure that the Microsoft DAO 3.6 Object Library is enabled in
the application ...

R. Hicks

 

[·®·®]

I'm trying to convert my first ACCESS 97 project to Access 2003. I'm
receiving the above error when I try to compile a module. It stops on the
following:

Private Function CreateQueryResultTable(rsSource As Recordset, TargetTable
As String, ResultCols As Integer) As String

I think the bigger question is, "Does a paper exist that identifies the
differences between Access 97 and Access 2003 or likewise, VBA with VB.NET?"

I'm new at this and I'm thinking it is Recordset that is actually the issue.
I have seen reference to ADODB.Recordset, but chaning it to that does not
make a difference.