just extend the ADAPTERS dict in dal.py
http://web2py.com/books/default/chapter/29/06#Note-on-new-DAL-and-adapters
On Thursday, November 15, 2012 10:12:45 PM UTC+1, Simon Carr wrote:
>
> So would I just subclass MSSQL2Adapter and then change types dictionary
> values to match what MS Access expects to see?
>
> Once done, what do I have to do in order to make something like
> db=DAL('msaccess://.....') available to use?
>
> Thanks
> Simon
>
> On Thursday, 15 November 2012 17:02:04 UTC, Niphlod wrote:
>>
>> maybe there are only column type and fk adapters to rewrite. the place is
>> dal.py.
>> Look into MSSQL2Adapter class that redefines slightly MSSQLAdapter. The
>> same approach can be used for access.
>>
>> SQLite is often not scaleable enough but MS Access fits just nicely in
>>> the middle ground and is readily available on users machines.
>>>
>>>
>> I'm having a hard time believing MS Access outfasts SQLite in speed.
>>
>
--
