There is very little information on this topic available on the internet. I have found one post where a user asked if Web2Py could be used with MS Access and a few users including Massimo suggested that it might be possible using the MSSql driver. There was no further information to suggest that this idea has been tested yet.
While I understand the T-SQL is not entirely compatible with MS Access but most basic SQL statements such as Select, Update and Delete will work just fine. But in worst case I assume I should still be able to run raw SQL statements. If I wanted to Test Web2Py with PyODBC / MSSql to connect to MS Access what would the connection string look like? Bearing in mind that MS Access is a file based database and does not run behind an IP Address. Any help on this or anyone else's experience with Web2py and Access would be appreciated. Thanks Simon --
