Parameter limit for MS Access database

I know that the parameter limit for Sql server is 2100. I am won开发者_开发知识库dering if there is such a limit for MS Access database. Anyone knows about it?

I don't know much about Access, but I thought that Access has no stored procedures, only named queries? If so, the answer is whatever you can fit into "approximately 64,000" characters:

http://office.microsoft.com/en-us/access-help/access-specifications-HP005186808.aspx

But it would be interesting to know why you need to know: for almost all developers almost all the time, actually encountering database capacity limits like this is a danger signal that you have design or implementation issues.

Access 2007 doesn't allow more than 100 parameters. If you go over that limit, you will get a Query is too complex error.

I'm not sure if the situation has changed for Access 2010.