Access 2000 and VB 6

From: dauster (dauster_at_discussions.microsoft.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 11:37:04 -0800

Using VB6, I create a ADODB connection to an Oracle 8i database. The I open a
recordset based on an SQL string. Now, how can I show the data in the
recordset in an ACCESS report?

I can display the data in an ACCESS form but setting the form's record
source to the recordset but can't for the ACCESS report. Why?

Thanks!

Relevant Pages

  • Re: ADO dll
    ... connect method need be used to connect to the database. ... >Server Name, Authentication) ... >Recordset returned as clsXA.Recset ... >Access Type - SQL to access database with a SQL string ...
    (microsoft.public.vb.database.ado)
  • Re: Connection types and speeds
    ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
    (microsoft.public.access.queries)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... return another column from the database that stores the users 1st name :-) ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ... ' validate variables against database ...
    (microsoft.public.inetserver.asp.db)
  • Re: Recordset problem
    ... This is why I'm trying to use Recordset. ... Dim strPrice As String ... >> Dim dbs As Database ... >You don't need to open the database object dbs before ...
    (microsoft.public.access.modulesdaovba)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ... ' validate variables against database ...
    (microsoft.public.inetserver.asp.db)