Access LIMIT Query Problems

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?

 

What happens if you take the ORDER BY part off?

 

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

 

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.

 

No LIMIT key word found in MS Access