Using MS Access in Rails application

There is no default support to use MS Access database with our Rails applications. Among many solutions while googling, I have found 2 solutions which can be easily used and managed in our projects. These solutions can be found in the following links –

1. http://blog.behindlogic.com/2007/07/msaccess-for-rails-heres-your-rough.htm
2. http://rubyonwindows.blogspot.com/2007/06/using-ruby-ado-to-work-with-ms-access.html

Solution one is more preferable than the second one. Using this solution we can do same operations that we do using ActiveRecord.

If you could not use the solution one for your expected result then you can use second solution. But this solution is not that much intuitive. Using this solution, if you want to any operation then you will need to write SQL yourself.