In Memory Dao Recordset

I need to retrieve an average of 150,000 records. To open Recordset object, you have to use the following syntax:. 2) One possible benefit that ADO provides is that of disconnected recordsets, which may have an advantage or at least suggest some architectural alternatives in your wireless network setup. 12 adapter (all defaults), MySql. In this video we are talking about the DAO recordset In VBA and how to formulate one easily. This is because, to the best of my knowledge, DAO requests all of the data and then filters it down in memory on the local machine. By using ADO and Delphi, you can create database applications that do not rely on the BDE. In ADO, this object is the most important and the one used most often to manipulate data from a database. Dim rsStudID As DAO. When working with a forward-only, read-only Recordset - that is, the default ADO Recordset - the RecordCount property always returns -1. First, ADO supports a disconnected model. GetAllProjects(){ Dim sql as String Dim rs as RecordSet sql = "SELECT * FROM project ORDER BY number DESC" rs= APP. As the arguments seem to be ok, it's relevant that we know if you declared an ADO recordset or a DAO recordset, and the connection object as well. You can use the array as an in-memory copy of your data to speed data processing and eliminate locking and storage problems on the server. ini in the same folder as the file being imported. Universal Data Access Using ADO In this chapter we're going to start getting to grips with what will definitely be the database access technology of the future - ADO. It doesn't involve recordsets. Distinct, grouping rows of Excel data, running multiple selects etc. Recordset, ( existing in memory only ) how can I use that array to update. I tried: Dim r As DAO. The DAO Recordset is basically a VBA object which enables us to gain access to information stored in database tables or queries via code. The Overall Objective in this Courseware is to give a Hands-on Approach to develop different projects in Visual Basic-6. Originally, Access offered only one way to create a recordset: DAO (for Data Access Objects). The code originally used to run the sql statement, insert a line into a temporary table, loop and insert the next line and so on. 1, I found that the program does not work with the new version. It has been created collecting TMs from the European Union and United Nations, and aligning the best domain-specific multilingual websites. I searched the net and only found classic ASP examples or all DB driven examples. 's article: Using Custom Recordsets. Dynaset:- A Dynaset is temporary set of data from one or more tables. I would like to stay with the recordset type as my current code is built around it and I use the recordset. DAO is optimized for the Microsoft Jet database engine and provides a set of data access objects (database objects, tabledef and querydef objects, recordset objects, and others). We use the Office file open dialog for this. Dim rs As DAO. It may or may not be of use in yours, but if you find this useful, drop me a line at [email protected] A dynaset-type Recordset object is a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables. 0 using intrinsic, professional and user–created ActiveX controls and also develop projects using databases, DAO’s, ADO’s, DLL’s, Documents, Crystal Reports etc. Is that true? Is there anyway to borrow some tools from Access to accomplish this join?. You can use the array as an in-memory copy of your data to speed data processing and eliminate locking and storage problems on the server. A dynaset-type Recordset object can contain fields from one or more tables in a database. In this discussion we will: Discuss a form that uses VBA and DAO to replicate the built-in functionality of the attachment dialog; Discuss the ShellExecute Win API. This is because, to the best of my knowledge, DAO requests all of the data and then filters it down in memory on the local machine. GetAllProjects(){ Dim sql as String Dim rs as RecordSet sql = "SELECT * FROM project ORDER BY number DESC" rs= APP. ASP demonstrates how you can use a stand-alone recordset. If there is a match, the pointer will point to the record specified by the seekoption parameter. Dim PF As DAO. The ADO Recordset is very similar to DAO's Recordset and RDO's rdoResultset object. (All of the following assumes you are trying to use an Access/JET database as the data source. The default setting is. You will need to balance the power of in-memory recordsets against the higher price in speed and memory consumption. The DAO Recordset is basically a VBA object which enables us to gain access to information stored in database tables or queries via code. The Sorted property isn't much more complicated. Recordset Set rstPersons = New ADODB. Disconnected Recordsets. OLE DB is bound to replace ODBC as the defacto data connectivity standard and ADO is the interface that most applications will use to access data functionality. getTime() parameter to your URL. I was just wondering if there's a way to populate a recordset in memory, use it, and then remove it from memory when done without having to store it to a table first. If I run the same select and psqlodbc drivers with VB6 and ADO it works OK. The DAO Recordset is basically a VBA object which enables us to gain access to information stored in database tables or queries via code. Yes, a static ADO recordset (that's the biggest difference of data location) places a heavier client-side memory burden - but that is really the responsability of ADO to maintain. Originally designed as an ODBC layer for Microsoft Visual Basic version 2. DA: 24 PA: 13 MOZ Rank: 1. The second obstacle is the type of recordset you are using with which version of Access. The use of the recordset makes it possible to reflect the modifications immediately to the database as well as all associated open recordsets. ' Open the Recordset and use dbOpenDynaset so we can modify records. Recordset Dim oRstTrie as DAO. You use it to manipulate data, or to pass data around. OpenRecordSet(anotherSQL) then I wonder if the. I've read an SQL join can not be done to two recordsets in VBA memory. This article highlights ten common traps with DAO recordsets in VBA code. By using ADO and Delphi, you can create database applications that do not rely on the BDE. Recordset Set db = CurrentDb Set rs = db. Summary: With LEADTOOLS you can save an image from the ActiveX control to memory. TempTradesTime here is the temporary recordset i have created in memory. While interpreted ASP code is looping through the Recordset, making decisions about what to display and response writing some HTML, the server is using limited resources holding open a connection to the database. Changing the CursorLocation = adUseClient causes a problem when executung the SQL (multiple-step operation generated errors). Universal Data Access Using ADO In this chapter we're going to start getting to grips with what will definitely be the database access technology of the future - ADO. This type corresponds to an ODBC keyset cursor. Well all object variables are just pointers to the objects themselves in memory - created by the components of the library in question. You use it to manipulate data, or to pass data around. This returns only a temporary Recordset with only one single Record (containing only one single Field with the desired result). Caching recordset in Memory 843833 Apr 17, 2006 7:25 PM Hi, I am using Data Access Object, I want to cache recordset in memory. Here is the original post: 1) You can fabricate an in-memory ADO recordset. So the cursor maintains the row pointer to the recordset selected by the cursor DECLARE. Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface; 1 GB when entering data programmatically. ASP demonstrates how you can use a stand-alone recordset. SYMPTOMS: A Microsoft Access database has begun to bloat (or grow rapidly in size) after you implement Data Access Objects (DAO) to open a recordset. The following is a snippet of some code we use to analyze our website hits. 12 adapter (all defaults), MySql. By using ADO and Delphi, you can create database applications that do not rely on the BDE. Recordset Object of DAO A Recordset object can act as temporary table that stores the(temporary)data in the memory of the computer after you retrieved the data from the table or query. After creating recordset object, use VBA to programmatically access the data. Please try again later. DAO Recordsets to Modify, Add, and Delete Rows. A dynaset-type Recordset object is a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables. The following code segment defines the relationship's attributes. Tip: Always close the Recordset object after using it, to free system resources. In ADO, it is possible to save an ADO recordset and store it locally. You use it to manipulate data, or to pass data around. 0 snapshot-type Recordset opened with the dbForwardOnly. An article regarding the relative efficiency of using SQL cursors, as compared to using while loops in SQL programming, made me reconsider the approach I had begun to use on this VB6 to VB. Database Dim rs As DAO. Recordset End Sub. You can navigate through the recordset and do whatever processing you are legit to do. This single poor object model behavior has led to the misconception that VB leaks memory unless you explicitly set all. If I declare a object var (RecordSet) and initialize it with Set RecordSet = DB. Dim oRSet As ADODB. Hi all, I've been banging my head against this problem for a while now and making no progress and am hoping someone cleverer than me can provide some assistance in solving it, or point me in the right direction. 6, the usage then increases by about 3Mb per second. A dynaset-type Recordset object can contain fields from one or more tables in a database. I have a design question. For example I have an Array with 2 fields. These properties concern the way data are presented, possible filters, how it can be used to enter of edit data etcetera. If I run the DAO test with driver "Devart ODBC Driver for PostgreSQL" it works OK. Both are types of recordsets. It does not try to fill-up an entire Rs-Memory-Representation. This is essentially the same technique you use in DAO except that you must declare the variable as being of type DAO. 3268 Cannot set the property of an object which is part of a Database object. the recordset was created with the new class wizard and used a database that was created with an old version of Access. The second obstacle is the type of recordset you are using with which version of Access. Discuss each question in detail for better understanding and in-depth knowledge of Mixed. If it is greater than or equal to 100, the Recordset can use up to the specified number of kilobytes in memory. All Recordset objects are constructed using records (record: A collection of data about a person, a place, an event, or some other item. If it is 0, the Recordset can use unlimited memory. I am sure you would have solved the problem by now. If I only change the reference to DAO 3. When working with a forward-only, read-only Recordset - that is, the default ADO Recordset - the RecordCount property always returns -1. The reason this works is that the record set operations are written to memory (transaction buffer) rather than directly to the hard disk. Here is the code for the form_load event (note that I don't have any code to bind to the combobox yet since I don't know what the correct usage is; the. In the Open event of the report:. (Since recordsets exist only in memory, the Recordsets collection is not a collection of persistent objects. A new feature of ADO 2. You should close an open Recordset by using the DAO Recordset. append(data) data. 1 Chapter 1 Introduction to MySQL Connector/ODBC The MySQL Connector/ODBC is the name for the family of MySQL ODBC drivers (previously called MyODBC drivers) that provide access to a MySQL database using the industry standard Open Database. If there is no match, the record pointer will be placed at the end of the Recordset. Disconnected Recordsets. 's article: Using Custom Recordsets. MyMemory is the world's largest Translation Memory. ActiveX Data Objects (ADO) is another API to data and information. I have an application that will have at max 8 concurrent users and 80% of the time it will have two. exe with input SQL file, and finally, the MariaDB MySqlImport. Reporting: Microsoft Access: How do I create a recordset from another recordset? This post has been flagged and will be reviewed by our staff. Although I liked how simple and concise the shaped recordset “class” was (especially the built in calculations that shaped recordsets can perform) the time it takes to load and work was incredibly long. Recordsets enable us to reference field names, search for records, filter records, count records. Recordset = rsStudID This will populate the liststudID List Box with source type "Table/Query" with the data very quickly. Normally this would be on SQL Server, I might just create a Recordset Oject and run this SQL statement again in 1 milisecond. If I run the same select and psqlodbc drivers with VB6 and ADO it works OK. I want to read data into a recordset, close the connection to source, and use the snapshot from memory. Universal Data Access Using ADO In this chapter we're going to start getting to grips with what will definitely be the database access technology of the future - ADO. It provides text processing, numerical computation and multi-threading functionality. The term snapshot can be a source of confusion. ADO allowed you to subscribe to events directly to the connection or recordset objects; DAO has NO events at all. The ADO Recordset has the additional advantage of allowing complete disconnection from the back-end database system (this is called a "disconnected" Recordset) as well as built-in cross-process and cross-machine remotability. It then runs the SQL statement to create a new table in Access then reads the recordset into the variant array using the GetRows statement. Excel Macro and VBA Data/Pivot Table PivotCaches Represents the collection of memory caches from the PivotTable reports in a workbook. GetRows returns the Recordset's current contents in a dynamic array. Dim frm As [Form_Agency Info] Memory. platform_sdk. Set the Recordset object to Nothing to completely eliminate it from memory. Visual Basic 6. I have two recordsets filled with data in excel VBA: rs1 and rs2. 12/16/2013 · A recordset is basically an in-memory container for data. Sometimes you need to create data access objects on-the-fly. If the VBA is just used in Access only, it is good to use DAO. For more information on using stand alone Recordsets be sure to read Ryan S. Close recordsets ACC2000: To Help Prevent Database Bloat, Explicitly Close Recordsets - 209847 mentions that "In Microsoft Access, if you use Data Access Objects (DAO) to open a recordset and you do not explicitly close the recordset, DAO may hold onto the memory that it used for its previous compile until the next recordset is opened. This model furnishes facilities for creating databases, defining tables, fields and indexes, establishing relations between tables navigation and querying the database, and so on. Recordset End Sub. Well all object variables are just pointers to the objects themselves in memory - created by the components of the library in question. Here are 9 steps to convert your DAO project to ADO. ADO, on the other hand, defines the RecordCount property as. The key parts of the Transaction processing are bolded. 6 Object Library. This page is a reference for developers, demonstrating how to use the DAO library to programmatically create, delete, modify, and list the objects in Access - the tables, fields, indexes, and relations, queries, and databases - and read or set their properties. If you do not release a recordset's memory each time that you loop through the recordset code, DAO may recompile, using more memory and increasing the size of the database. DAO offers five types of Recordset objects: table?type, dynaset?type, snapshot?type, forward?only?type, and dynamic?type. However, I ran into several problems. The ADO Recordset is very similar to DAO's Recordset and RDO's rdoResultset object. 0 is the ability to open a recordset created from your Access database (or any other database, including SQL Server and Oracle) and save the recordset to. We're part of Translated, so if you ever need professional translation services, then go checkout our main site. I have a design question. Here is an ADODB example in Access VBA for Inserting a record into a local Access table using the ADODB command object and then reading the contents of the table using an ADODB Recordset object. For more information on using stand alone Recordsets be sure to read Ryan S. Database Dim rs As DAO. Recordset RecordCount property always returns -1 even though I can access the Fields and see the data. Similarly, close an open Workspace object using the Workspace. Depending on the cursor type, you can browse and change the row data. The second obstacle is the type of recordset you are using with which version of Access. Set rst currentDb. OpenRecordset (“Select ID from ids”) To set a recordset object, using the OpenRecordset method of a database object. XX for DDL etc" If its not in the list, then you will need to click the ADD button and. The actual number will be fewer because of tables opened internally by Microsoft Access. The next time through the loop, we assign the name of the table in that record to sCurrentTable. I have two recordsets filled with data in excel VBA: rs1 and rs2.   However, when I loop to pass through on the second value the recordset requeries itself - this is not required as the recordset is already in memory. When the form containing the ADO Data Control loads into memory, the ADO Data Control will connect to data using the ConnectString property and return a Recordset fitting the specifications of the RecordSource property. The syntax of this method is: Set Variable = Database. I should clarify that DAO recordsets will be in memory just as well as ADO recordsets, the difference being that I find DAO being a bit more eager to flush it to the disk (even if not saved to an actual table). I have an application that will have at max 8 concurrent users and 80% of the time it will have two. 3270 Property not found. OpenRecordset(Name [,Type [,Options [, Lockedit ] ] ]) Type refers to: Table, Dynaset, Snapshot. You open a recordset, then disconnect it, so you can still work with the data in memory, but not have to leave a database connection open. DAO Programming Code Examples. VB6 is Microsoft Visual Basic 6. Recordsets are mainly used in database environments - for example, it's an invaluable help when programming in MS Access. How to get Column Names from your recordSet Object. Access Vba Create Recordset From Recordset. Note: When you use OpenRecordset on a query or attached table Access defaults the Type property to dbOpenDynaset. Ở đây ta nói rõ Database và Recordset là thuộc loại DAO để phân biệt với Database và Recordset thuộc loại ADO (ActiveX Data Object) sau nầy. Accessing Databases Using ADO and Delphi By: Charles Calvert. Recordset Object to our Custom Class Object. This recordset remains in memory until you close the form, when the Close form destroys it. The data never gets written back, it is read only and not particulary dynamic. The code on the on click event of your button will open a recordset on this query and loop through it's records to send the emails. You use it to manipulate data, or to pass data around. If a form is based on a query, for example, referring to the Recordset property is the equivalent of cloning a Recordset object by using the same query. The default form sorting does not appear to work when you have your form bound to an ADO recordset. test-ignore. Dim wksp As DAO. Microsoft Access 2010 tutorial: In this section, you will learn how to open recordset object of DAO. Use VBA to get the correct number of records in a Recordset object. 6 Object Library. This page is a reference for developers, demonstrating how to use the DAO library to programmatically create, delete, modify, and list the objects in Access - the tables, fields, indexes, and relations, queries, and databases - and read or set their properties. SYMPTOMS: A Microsoft Access database has begun to bloat (or grow rapidly in size) after you implement Data Access Objects (DAO) to open a recordset. The RecordSet object contains a Fields collection and a Properties collection. Set the Recordset object to Nothing to completely eliminate it from memory. Recordset ' Instancie la base de données Set oDb = CurrentDb ' Ouvre le curseur retournant tous les clients Set oRst = oDb. Here is the code for the form_load event (note that I don't have any code to bind to the combobox yet since I don't know what the correct usage is; the. NET object used for holding database rows in a program's memory space. ADODB reads and writes data from and to persistent (physical) tables only. MS Access DAO recordset + SQL Server: how to get the ID of a newly inserted record Sometimes when inserting records programmatically you want to create a parent record first, then add records into related tables where the Foreign Key is on an autonumber field. I was hoping to find a way that is neater/reusable than typing out half a dozen lines of txtField. Also, from memory, isn't DAO the recommended method of accessing data in VBA within the Access environment? That's the older less efficient method than ADO. You use it to manipulate data, or to pass data around. The DAO and ADO libraries both have a Recordset object, but with different methods, properties, and options. ASP Sample Program DirList. Add new a row to recordset : Recordset Add Update Delete « Access « VBA / Excel / Access / Word. These properties concern the way data are presented, possible filters, how it can be used to enter of edit data etcetera. To find out the original field name, check the Field object's SourceField property. …In this movie, I'll show you the code to do that. recordset ' empty, (target) dim varStatusT as variant dim varRefByT as variant dim varProcDate as variant dim varHospT as variant dim lngPatientFK as long dim strPxNotes as string set db = currentDb. If it is 0, the Recordset can use unlimited memory. VBA for Working with the Access Attachment Datatype A continuous form to manage attached documents. 0 using intrinsic, professional and user–created ActiveX controls and also develop projects using databases, DAO’s, ADO’s, DLL’s, Documents, Crystal Reports etc. You use recordsets to pull information from what might be a ginormous amount of information in a database, so that you are working with a smaller set of data at one time. Name Next End Sub The following example uses the Recordset property and the Recordset object to synchronize a recordset with the form's current record. This is because, to the best of my knowledge, DAO requests all of the data and then filters it down in memory on the local machine. Similarly, close an open Workspace object using the Workspace. I need to retrieve an average of 150,000 records. Data Access Objects, or DAO, is a powerful programming model for database services. data_services. If it is greater than or equal to 100, the Recordset can use up to the specified number of kilobytes in memory. Add two buttons to the form, and set their Caption properties to the following: Command1 - DAO Command2 - SQL Then, copy this code: Private dbWork As Workspace Private dbData As Database Private dbTabl As Recordset Private dblTime As Double. If you are still using DAO then you need to change. (Although DAO is generally considered more efficient for working with Jet databases, ADO's disconnected Recordset has its advantages. I have also included a sample BAS file that will create an Access database file. With DAO, you can set the PartialReplica property on a Relation which allows that Relation to be used in partial replication. A more practical way is to use DAO instead of ADODB. This is in contrast to, for example, the dynaset type of recordset, which brings only bookmarks into memory when the recordset is established. Not our VBA variable pointing. It may or may not be of use in yours, but if you find this useful, drop me a line at [email protected] Dim PF As DAO. Universal Data Access Using ADO In this chapter we're going to start getting to grips with what will definitely be the database access technology of the future - ADO. As far as the SELECT INTO method is concerned I found the same problem in that it does not work with an open workbook. In the Open event of the report: Private Sub. The code on the on click event of your button will open a recordset on this query and loop through it's records to send the emails. It allows you to create a recordset based on a query, and recrieve the resulting set using the following functions:. Recordset, ( existing in memory only ) how can I use that array to update. The primary role of many Microsoft Office solutions is to turn raw data into usable information. The default form sorting does not appear to work when you have your form bound to an ADO recordset. DAO Recordset With Access Office 2002 Database I have a very old MFC project that uses CDaoRecordset. Using AddNew/Update with DAO recordset creates a blank record in addtion to the new record. The DirList. The Recordset property returns the Recordset object that provides the data being browsed in a form, report, list box control, or combo box control. Recordset End Sub. Loop through all fields and copy them. 9366 - Resource Leak when calling the WhereIs method in the MouseMove event of a VC++ app. I have a design question. Similarly, close an open Workspace object using the Workspace. DAO stands for Data Access Object. DAO versus ADO. I have a very simple Microsoft Access subroutine that continuously loops until a condition is met. This software integrates seamlessly into your project and lets you call the form functions whenever you need them - this way, don't need to spend so much time creating about codes. In this video we are talking about the DAO recordset In VBA and how to formulate one easily. Note: When you use OpenRecordset on a query or attached table Access defaults the Type property to dbOpenDynaset. movenext 'press Ctrl+G to see. The recordsets are identical and they are disconnected. This will be accessed through a DAO layer, and an arraylist of objects will be populated from the recordset. Chapter 14 - Working with the Data Access Components of an Office Solution. Select the sort of code you want to use: Add, Update, Read or Browse 4. data_services. ActiveX Data Objects (ADO) is another API to data and information. Recordset RecordCount property always returns -1 even though I can access the Fields and see the data. It doesn't involve recordsets. Disconnected Recordsets. It provides text processing, numerical computation and multi-threading functionality. Make sure the new workbook is NOT open and I think you need to have saved the current workbook at some. methods similar to Access 97's ODBCDirect Recordset. Not our VBA variable pointing. MoveLast) to get an accurate count. By default, all rows should go into your recordset (wich is a memory image), then whatever, SQL server, MySQL, Oracle, or even Access, you are in trouble differently with out of memory, time out, and so on To solve this issue, you must understand how ADO or previously DAO, or more globally ODBC or JDBC work. I have joined the forum recently and have seen this post just now. This will be accessed through a DAO layer, and an arraylist of objects will be populated from the recordset. Although there is a Recordsets collection (the collection of all open Recordset objects in a database), it is not much use, except to list the open recordsets and their SQL statements, as in the following code sample:. You can navigate through the recordset and do whatever processing you are legit to do. A dynaset-type Recordset object is a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables. Recordset Set db = CurrentDb Set rs = db. It works with postgresql 7. Here's a short routine you can add to your Form_Unload event (or some other terminating code module) that will close all open DAO workspaces, databases, and recordsets and release the memory reserved by these objects. Yes, a static ADO recordset (that's the biggest difference of data location) places a heavier client-side memory burden - but that is really the responsability of ADO to maintain. The use of the recordset makes it possible to reflect the modifications immediately to the database as well as all associated open recordsets. However, I ran into several problems. Within the loop, I am accessing a single linked MySql table (via ODBC) which has only one row and three small fields. In Memory, Stand-Alone, Disconnected ADO Recordset. First, ADO supports a disconnected model. Microsoft Access Performance Tips to Speed up Your Access Databases by Dan Haught, Executive Vice President, and Luke Chung, President of FMS. It enables direct binary database export of MDB or DBF files from ASP pages with one row of code. Visual Basic 6. Within the loop, I am accessing a single linked MySql table (via ODBC) which has only one row and three small fields. Query linked table slower if not table db is open? 7. The reason this works is that the record set operations are written to memory (transaction buffer) rather than directly to the hard disk. DAO Recordsets. Simply put: a recordset is a virtual table in your computer's memory. RecordSetObject. With the AddItem method the rows in the recordset could be transferred to the listbox. DAO Recordsets to Modify, Add, and Delete Rows. Thank you for helping us maintain CNET's great community. Snapshots and dynasets are the two types of Recordset objects from which forms can be based. Dim rs As DAO. 6, the usage then increases by about 3Mb per second. By default, all rows should go into your recordset (wich is a memory image), then whatever, SQL server, MySQL, Oracle, or even Access, you are in trouble differently with out of memory, time out, and so on To solve this issue, you must understand how ADO or previously DAO, or more globally ODBC or JDBC work. Here is an example: Private Sub cmdSetOfRecords_Click() Dim rstPersons As ADODB. stored in memory and we are able to loop through the records one at a time, manipulating the data as we go. Cycle through the record to look for a certain criteria: in this example the Field is state and the search string is “CO” for Colorado. Dynaset-type Recordset: the result of a query that can have updatable records. Originally posted by Rawr: Why not create an empty Table object with the columns you want, and then base the Recordset off of that? DAO had TableDef; I don't remember the ADO equivalent at the moment. 12 adapter (all defaults), MySql. an "in-memory ADO record set". Depending on the cursor type, you can browse and change the row data. 12/17/2013 · A recordset is basically an in-memory container for data. stored in memory and we are able to loop through the records one at a time, manipulating the data as we go. Any of these ideas will solve the clash: Remove the reference to either the ADO or the DAO library. NET source code resources close-connection methods so don't often use the recordset for memory access/storage. ADODB reads and writes data from and to persistent (physical) tables only. Here, we will build a Class Module for data processing task, by passing a DAO. It works with postgresql 7. This returns only a temporary Recordset with only one single Record (containing only one single Field with the desired result). Let's say you inherit a copper-plated widget manufacturing company from an uncle. Today I want to show how you may execute the stored query in MS Access database (mdb-file) and process the records in query (view). DAO is optimized for the Microsoft Jet database engine and provides a set of data access objects (database objects, tabledef and querydef objects, recordset objects, and others). It enables direct binary database export of MDB or DBF files from ASP pages with one row of code. Recordset For Each fld in rst. Dynaset-, snapshot-, and forward-only-type Recordset objects are stored in local memory.