[Last Call] Learn how to a build a cloud-first strategyRegister Now


Copying a recordset

Posted on 2008-11-04
Medium Priority
Last Modified: 2010-04-30

I'm trying to copy a recordset, but I'm wanting to copy the data and fields, and not wanting to use the methods. Is there someway I can use a recordset to hold the data without tying it to a database connection? Essentially using a recordset as a type of class?

Question by:Unimatrix_001
LVL 54

Accepted Solution

Ryan Chong earned 2000 total points
ID: 22883413
Recordset is an object designed to hold data from a record/data source, you must connect it to a database in order to use it.

If you don't want connect the recordset object to a database, then you must create your own class objects to handle your requirements.

Author Closing Comment

ID: 31513398
Shame... Thanks anyways.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month18 days, 1 hour left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question