conecting with a MsAcces DB by dao

[Tim Chase]

>> , Access can retrieves a not empty recordset but my python code
>> retrieves a empty recordset.
> 
> Which is exactly what it _should_ return on that query, unless you have
> records with "e*" in column field1.
> 
> The proper SQL clause is:
> 
>      ... WHERE field1 LIKE 'e*' ...


which would also return an empty recordset unless the OP has 
records with "e*" in column field1...

the proper SQL clause would be

	... WHERE field1 LIKE 'e%' ...

(in SQL, the "%" and "_" are used as wildcards, not asterisk and 
question-mark respectively as they are in most shell expansions)

:)

-tkc