There are a few ways to go about this.
1. Modify the sqlserver_adapter.rb file to use Access sql instead of sql server sql. It of course would have the DBI and ADO.rb dependencies.
2. Get a generic ODBC adapter working, and just call Jet files thru ODBC (should work for non-Win32 platforms as well).
3. Write an ADODB_adapter.rb file that would sidestep the ADO.rb DBD and DBI.
- – - – - – - – - – -
I am working on creating an msaccess_adapter that uses MsAccess SQL (MS JET SQL with Access limitations), going straight through ADO without DBI or ODBC. When it’s done I plan to update this page, but check http://blog.behindlogic.com if you really want it bad!