# Access Databases and ADODB

**URL:** <https://www.ruby-forum.com/t/access-databases-and-adodb/179679>\
**Category:** Ruby\
**Created:** [December 1, 2009, 6:42pm UTC](https://www.ruby-forum.com/t/access-databases-and-adodb/179679 "2009-12-01T18:42:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mschwab](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/59ef9b/32.png) [@mschwab](https://www.ruby-forum.com/u/mschwab)\
**Post date:** [December 1, 2009, 6:42pm UTC](https://www.ruby-forum.com/t/access-databases-and-adodb/179679/1 "2009-12-01T18:42:56Z")

</div>

For accessing Jet databases with ADODB, this is an interesting article:

> **[Ruby on Windows](http://rubyonwindows.blogspot.com/search/label/access)**
>
> On using the Ruby programming language on the Microsoft Windows platform

However I can’t find more complete information on the methods available.  
Can anyone suggest a good source?

---

<div class="post-metadata">

**Author:** ![mschwab](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/59ef9b/32.png) [@mschwab](https://www.ruby-forum.com/u/mschwab)\
**Post date:** [December 2, 2009, 4:04am UTC](https://www.ruby-forum.com/t/access-databases-and-adodb/179679/2 "2009-12-02T04:04:14Z")

</div>

Mike S. wrote:

> For accessing Jet databases with ADODB, this is an interesting article:
> 
> [Ruby on Windows: access](http://rubyonwindows.blogspot.com/search/label/access)
> 
> However I can’t find more complete information on the methods available.  
> Can anyone suggest a good source?

Beyond this…

> **[Using Ruby & ADO to Work with MS Access Databases](http://rubyonwindows.blogspot.com/2007/06/using-ruby-ado-to-work-with-ms-access.html)**
>
> A reader in the Ruby forum recently asked about using Ruby to get data from a Microsoft Access database. This can be done easily using the ...

…what, specifically, would you like to know?

David

> **[Ruby on Windows](http://rubyonwindows.blogspot.com)**
>
> On using the Ruby programming language on the Microsoft Windows platform

---

<div class="post-metadata">

**Author:** ![mschwab](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/59ef9b/32.png) [@mschwab](https://www.ruby-forum.com/u/mschwab)\
**Post date:** [December 2, 2009, 9:04am UTC](https://www.ruby-forum.com/t/access-databases-and-adodb/179679/3 "2009-12-02T09:04:21Z")

</div>

Hi David

I’m trying to see if your example maps to VBA.

For VBA you need to call recordset.Fields.Refresh whereas you don’t do  
that in your example. How’s that work?

Also there are related methods like MoveFirst, MoveNext, Update, Addnew.  
I could experiment to see if analogies exist under ruby win32ole, but I  
hoped it might be documented somewhere. Where did you look?

Finally - VBA has more parameters in the Open eg adOpenDynamic.

How are you getting on with your book?