Please be aware that the odbc-rails adapter doesn't currently support
MS Access. The adapter isn't completely generic in that the adapter
requires some database-specific information which ODBC cannot provide.
Consequently, the adapter contains specific entries for each database
currently supported. However, it's straightforward to modify the
adapter to support a new database for which an ODBC driver exists.
Alternatively, you could export your Access tables to one of the
If you were to do this, your database.yml file should contain
something similar to:
i.e. dsn refers to a Data Source Name configured with your ODBC