in reply to MS Access through ADO and ODBC DSN

The driver should be "Microsoft Access Driver (*.mdb)" not "Microsoft Access Driver(*.mdb)". Whether that will be enough for SQL::Abstract::Limit to select the right syntax is a question.

Look into HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI for the list of installed drivers.

Jenda
Enoch was right!
Enjoy the last years of Rome.

Replies are listed 'Best First'.
Re^2: MS Access through ADO and ODBC DSN
by zer (Deacon) on Aug 31, 2009 at 20:09 UTC
    Thank you, this worked like a charm!