I know that the parameter limit for Sql server is 2100. I am wondering if there is such a limit for MS Access database. Anyone knows about it?
+1
A:
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.
Pondlife
2010-09-01 15:45:33
In most of cases, I don't worry about it, but I have got scalability issue here. I have groups of items to be queried. I need to run a query for selected items. All items are passed into queries through parameters. The number of groups are limited, normally not exceeding 100. The problem is that this 100 groups could contain more than 2100 items, thus causing parameter number to be over 2100.
Thomas
2010-09-01 16:00:46
Sounds like you should put that data in a table, and then you can join to it.
David-W-Fenton
2010-09-01 19:54:46
+1 for the danger sign warning.
David-W-Fenton
2010-10-13 00:43:44
A:
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.
hawbsl
2010-09-01 16:48:49