in memory recordset 1

[jurgen]

Can someone give me an example on how i can build a ADO recordset in memory based on a data in a database.

I'm trying to read the data into a ADO recordset, put it in memory, disconnect with the database and then using the data in memory through my application without having to go each time to the database, because the data is read-only

Thnx

Jurgen

 

[JerryKlmns]

Hi jurgen,

Placed in a module

Public rst As ADODB.Recordset

Executed anywhere in your application

Set rst = New ADODB.Recordset
With rst
   .ActiveConnection = CurrentProject.Connection
   .CursorLocation = adUseClient
   .CursorType = adOpenStatic
   .LockType = adLockReadOnly
   .Source = "SELECT Customers.* From Customers;" 
   .Open 'Here the recordset is opened
   .ActiveConnection = Nothing ' Here is disconnected from DB
End With

But adLockReadOnly doesn't allow changes either you disconnect it or not .......

 

[jurgen]

Thnkx works like a charme