开发者

Parameter limit for MS Access database

开发者 https://www.devze.com 2023-01-14 05:19 出处:网络
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 th

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消