How to make split page in MsAccess97

[Anon]

I have a ploblem about PHP with MsAccess,
I need to split the page from Database MsAccess.
I use SQL statement that inclued
"LIMIT 0,10", but it's has some error, I think MsAccess's not support this statement.

How can I do this, please sent the code to me or any other convince.

Thanks all.

[Anon]

You cannot use the LIMIT sql command in Access 97 because it is not supported. However, if I am not mistaken, Access 2000 does support LIMIT.

Hoever, regardless of which version you have, you will find a number of limitations in using MS Access as a web database. I personally use and recommend mySQL. Save yourself the wave of future headaches and switch before it's too late.

AaronZoller.com

<A HREF='http://www.aaronzoller.com'> http://www.aaronzoller.com </A>