# Connect to MS Access Database?

**URL:** <https://www.ruby-forum.com/t/connect-to-ms-access-database/122229>\
**Category:** Rails\
**Created:** [December 5, 2007, 7:04pm UTC](https://www.ruby-forum.com/t/connect-to-ms-access-database/122229 "2007-12-05T19:04:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![peter](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/278dde/32.png) [@peter](https://www.ruby-forum.com/u/peter)\
**Post date:** [December 5, 2007, 7:04pm UTC](https://www.ruby-forum.com/t/connect-to-ms-access-database/122229/1 "2007-12-05T19:04:29Z")

</div>

Can RoR easily connect and modify an Access database?

Also can RoR be used to easily create a web application that is just  
accessed over an intranet?

---

<div class="post-metadata">

**Author:** ![peter](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/278dde/32.png) [@peter](https://www.ruby-forum.com/u/peter)\
**Post date:** [December 6, 2007, 12:21am UTC](https://www.ruby-forum.com/t/connect-to-ms-access-database/122229/2 "2007-12-06T00:21:44Z")

</div>

Peter wrote:

> Can RoR easily connect and modify an Access database?
> 
> Also can RoR be used to easily create a web application that is just  
> accessed over an intranet?

i THINK you can connect.  
but how to use the driver is in question.

can you go directly to ODBC or have to use  
JDBC-ODBC? i am not sure.

creating the web is easy. but not like joomla!.  
you still have to spend some time learning the  
scripting langauge.

any comments from anybody else ???

---

<div class="post-metadata">

**Author:** ![peter](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/278dde/32.png) [@peter](https://www.ruby-forum.com/u/peter)\
**Post date:** [December 8, 2007, 6:09pm UTC](https://www.ruby-forum.com/t/connect-to-ms-access-database/122229/3 "2007-12-08T18:09:40Z")

</div>

I just was googling about just the same thing and stooped over this blog  
entry - it may help solving your problem.

> **[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 ...

(though, I haven’t tried it myself…)