Rails apps. with Microsoft Access as a back end?

Rails
1

Curious as to whether anyone out there has set up Rails as a front end
to a M$ Access DB?

I have done it with SQL Server, and have used ODBC to do it, so I know
that this is certainly possible.

I’m interested in gotchas, and good advice.

I’m not interested in hearing questions about why someone would want to
do such a silly thing ;).

Thanks,
Wes

2

Hi Wes,

On Wed, 2009-07-08 at 18:13 +0200, Wes G. wrote:

I’m not interested in hearing questions about why someone would want to
do such a silly thing ;).

Understood. Just wanted to send my sympathies :wink:

Best regards,
Bill

3

Never tried it. I think the lack of an adapter is what kills this. I’d
be curious to hear whether the sqlserver adapter in ODBC mode could be
fooled into hitting msaccess w/the right connect string…

4

Roy P. wrote:

Never tried it. I think the lack of an adapter is what kills this. I’d
be curious to hear whether the sqlserver adapter in ODBC mode could be
fooled into hitting msaccess w/the right connect string…

Good point. Might be that the connect string setup would have to be
overwritten, but I’m assuming the SQL conversation should work fine.

WG