How to use SQL "LIMIT" keyword against an MDB file

I'm trying to adapt a PHP script that was written to use MySQL, so
that it will work with an MSAccess MDB file.

An important part of the script makes use of the SQL "LIMIT" keyword
available in MySQL. eg: "SELECT MyField FROM MyTable LIMIT 40,10" to
select 10 records beginning at the 41st record.

Can anyone tell me how I can achieve this same functionality when
using ODBC functions to access an MDB file? I think I can set ROWCOUNT
(or possibly TOP) to retrieve only 10 records but how do I get it to
start at the 41st record?
.

Relevant Pages

  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... I'm trying to adapt a PHP script that was written to use MySQL, ... that it will work with an MSAccess MDB file. ... using ODBC functions to access an MDB file? ... explanation of at least one way...which falsifies your claim, ...
    (comp.lang.php)
  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... I'm trying to adapt a PHP script that was written to use MySQL, ... when using ODBC functions to access an MDB file? ... Access does not support LIMIT clauses. ...
    (comp.lang.php)
  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... I'm trying to adapt a PHP script that was written to use MySQL, ... when using ODBC functions to access an MDB file? ... BULLSHIT!!! ...
    (comp.lang.php)
  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... I'm trying to adapt a PHP script that was written to use MySQL, ... that it will work with an MSAccess MDB file. ... using ODBC functions to access an MDB file? ... Access does not support LIMIT clauses. ...
    (comp.lang.php)
  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... I'm trying to adapt a PHP script that was written to use MySQL, ... when using ODBC functions to access an MDB file? ... Why don't you try just not being an arrogant asshole in the first ... have the same functionality as you would with an SQL server doesn't it? ...
    (comp.lang.php)