Categories

Main
Database
Java
Microsoft.NET
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
ColdFusion
Crystal Reports
Delphi, C etc
JAVA
Microsoft.NET
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
XML & XSLT
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
Applications & Tools
Database Concepts & Design
EJB programming & troubleshooting
EJB design
General J2EE
XML & Web services
Web tier: servlets, JSP, Web frameworks
Performance and scalability
Industry news
TSS feedback
Mobicents Contributors
Mobicents Users
JSLEE Resource Adaptor Types
Planning JavaOne 2008
Sun Tech Days
Other Java conferences
Binary Web Services and XML
Metro and JAXB
GlassFish
GlassFish Plugins
Project jMaki
GlassFish WebTier
Mural
Java Development Tools
Java WS & XML Community News
JAXP
Java SE
6uN Early Access
Java Quick Starter
Java SE Snapshots: Project Feedback
JCK Forum
Feedback and Suggestions
JDK Distros
JDK Open Source
General JSR Discussion
JCP 2.6
JXTA Community Forum
ME Interest
ME Cool Apps
ME General Help
ME Feedback & Suggestions
ME Application Developer Interest
Blu-ray Disc Java
ME Developer Days
Squawk
Mobile Developer Alliance
OpenCable
LWUIT
JavaFX Script Language Discussion
OpenJFX General Discussion
Scene Graph
General Performance Discussion
Your Java Career
NetBeans 6.0
Servlets
JSP
JSF
Portals and Portlets
EJB and Other Java EE Technologies
Distributed Java
Object Relational Mapping
JDBC
Web Services
Swing / AWT / SWT / JFace
JNLP and Web Start
Java Micro Edition
Sockets and Internet Protocols
Threads and Synchronization
Performance
Applets
I/O and Streams
Other Java APIs
Game Development
Java in General (beginner)
Java in General (intermediate)
Java in General (advanced)
Programmer Certification (SCJP)
Developer Certification (SCJD)
Associate Certification (SCJA)
Web Component Certification (SCWCD)
EJB Certification (SCBCD)
Mobile Application Certification (SCMAD)
Architect Certification (SCEA)
Web Services Certification (SCDJWS)
XML Certification
Product and Other Certifications
Mock Exam Errata
Sun Certification Results
Authors' Corral
Book Reviews
Events
Bunkhouse Porch
Teachers' Lounge
Testing
OO, Patterns, UML and Refactoring
IDEs, Version Control and other tools
Ant, Maven and Other Build Tools
Linux / UNIX
Mac OS
HTML and JavaScript
XML and Related Technologies
Agile and Other Processes
General Computing
Security
Groovy
Scala
Other Languages
Struts
Application Frameworks
Other Open Source Projects
BEA/Weblogic
IBM/Websphere
Oracle/OAS
Apache/Tomcat
JBoss
Other Java Products and Servers
JavaRanch
Cattle Drive (java college)
Moderators Only
Trash Can
Jobs Offered
Jobs Wanted
Jobs Discussion
Meaningless Drivel
Programming Diversions
Blatant Advertising
Java Announcements
New To Java
Advanced Java
Java Applets
Networking
Threads and Synchronization
Java 2D
AWT / Swing
SWT / JFace
CLDC and MIDP
CDC and Personal Profile
Sun Java Wireless Toolkit
Enterprise JavaBeans
JavaServer Pages (JSP) and JSTL
Java Servlet
JavaServer Faces
Web Frameworks
Database
XML
Lucene
NetBeans
Eclipse
IntelliJ IDEA
JCreator
Other IDEs
Java Tutorials
Java Tips
Jobs Discussion
Jobs Offered
Jobs Wanted
Professional Certification
Forum Lobby
Java Blogs
Introductions
Reviews / Advertising
Suggestions & Feedback

Resources

Java Database
Linux
Coding
Mobile
Hardware
Software Development
Software Development
iOS,OS X
iOS,OS X
ORACLE
IBM DEVELOPER
IBM DEVELOPER
MSDN
MSDN


Tags

Microsoft Access

The database that comes with Office Professional. Access can handle tens of thousands of rows with ease and has great connectivity support for traditional database servers.

ADO Recordset to Report


I have an MSAccess (2k) front end containing Forms and Reports.
I have an MCAccess (2k) back end containing data tables.

I would like to do the following:
Use ADO.
Not connect the front to the back via linked tables.

I would like to somehow get the data from a reomote table into a local report.

I understand a Report requires a query or table and an ADO Recordset is neither.

One solution would be to dump the desired records from the remote table into a local temporary table with the local table as the record Source for the Report.

If this is the recommended solution, how would I do that without reading the individual remote records and writing them one by one to a local table.

Is there some way to do a "Insert into XXX Select * from YYY" type of syntax where the "from" table is a remote ADO recordset and the "to" table is a local table?

Thanks.

Since no one else is replying, I will be the bearer of bad news.  A report will only connect to a query or a table (linked or otherwise).  As to your other option of creating a table from the recordset, you will have to either have the structure of the table defined and then add the records one at a time, or create the table structure on the fly and then save the records one at a time.  There is no way to copy a recordset into a table without looping through the recordset one record at a time.

Since your ADO recordset is based on a SQL statement,  you could do away with recordset, and convert the SQL statement into an "INSERT INTO..."
statement to populate your temp table.

Thanks DCKunkle, 
you confirmed my bad vibes.

RedNeckGeek,
the problem with your suggestion is that it will create the table in the back end (remote) database and not in the current or front database where the report can get to it.

I guess I have two choices; create a temporary table and populate one record at a time or create a link connection to the back end.

Thanks again.

Quote:
	
	
		
			
				Originally Posted by MyerK
				
RedNeckGeek,
the problem with your suggestion is that it will create the table in the back end (remote) database and not in the current or front database where the report can get to it.
			
		
	
	


You're right...   I don't think my solution would work, unless you link the tables.  However,  you could link the tables with code,  build your temp table,
populate your temp table, and then drop the links again.


Related Links

Setfocus error! Came out of nowhere!!!!
Query Problem
Passing criteria from form to report
custom msgbox
Simple Codes
String Manipulation
Backup
dmax with date criteria
Linking Info in Forms
Appended records not recognized by a query
Problems with wheel mouse
Getting a Total of all Values (Not Just Top 25)
access 2k---adding records to a table from an "ungrouped" data access page----HELP!!!
Disable fields
User-Defined Functions in MS Access?
report - show only info of selected person