Access LIMIT Query Problems

[stickman373]

strSQL = "SELECT * FROM Table1 WHERE expire_date>#" & dteDate & "# ORDER BY post_date DESC LIMIT 3;"

If I take the LIMIT part off, it works, but add it on and it causes:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.

/mghdevelopment/index1.asp, line 463


Any ideas?

[Perrow]

strSQL = "SELECT * FROM Table1 WHERE expire_date>#" & dteDate & "# ORDER BY post_date DESC LIMIT 3;"

If I take the LIMIT part off, it works, but add it on and it causes:
What happens if you take the ORDER BY part off?

[dct]

I don't think Access has a limit keyword, you may be able to use TOP after the select keword e.g. select Top 5 * from .... that's how it works in MS SQL Server

[stickman373]

I don't think Access has a limit keyword, you may be able to use TOP after the select keword e.g. select Top 5 * from .... that's how it works in MS SQL Server

thanks, the TOP 5 worked :) Was wondering if it had the limit query

[Perrow]

I don't think Access has a limit keyword, you may be able to use TOP after the select keword e.g. select Top 5 * from .... that's how it works in MS SQL Server
I knew I figured it out recently, but had another problem that made me remove it so I had no place to look it up. Hope that solves the problem.

[sscheral]

No LIMIT key word found in MS Access