[RESOLVED] Paging with MS Access ...

interface

I've tried a fairly extensive search on several forums,
Google and PHP script sites hoping to stumble upon
a debate about paging with MS Access. From what I
understand is that MS Access doesn't support the
limit parameter in it's SELECT query ... e.g:

SELECT * FROM some_table limit $offset, $limit;

The answer to this question is unreasonably hard to
find on the net. So is almost everything which has to
do with PHP and MS Access ...
But I'm a go-getter, a 'don't let any database tell you
no' kinda guy ... But it seems like MS Access is the
'no programmer tells me what to do !' kinda database ...

So, if any, let me know 🙂

Sincerly,

interface

[edit]typo ... [/edit]

interface

I've found something that may help me, ADODB.
It says the following on it's website:

'...SELECT LIMIT emulation for all databases...'

Hmm, sounds yummy ! 🙂

I'm not trying to push the post to the top of the listing but maybe it is of help to someone else who is looking for the same solution.

If so, let us know how it went.

Sincerly,

interface

Thread solved thanks to Zend ...