Jim Dettman
jimdettman at verizon.net
Tue Dec 13 19:30:42 CST 2011
Ken, <<A Google search revealed that the 754 limit is very widely quoted, and even Microsoft's own page repeats this figure:>> Yes, it's been out there for many years. It was sometime in the A95/A97 timeframe that I first saw it documented. A quick check of the A2 manuals (yes, they are still on the shelf) does not have it listed as part of the specs. Unfortunately I don't have it loaded to test. Disks are still around somewhere but it's not worth the effort. <<So, I still think my theory stands -- but the numbers are correct only for Access 97. Does anybody have an ancient version of Access 97 they can test this on?>> For A97 I got 752. Still would like to know how it even started out as 754. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert Sent: Tuesday, December 13, 2011 05:59 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Form Lifetime Control Limit (Was: Advice on A2010....) > > Jim Dettman: > The default control names may have something to do with it, but it's not > the entire answer. I just ran the code below in A2003 and was able to > create 895 controls. I tried the same code in other versions as well: > > A2000 - 800 > A2002 - 894 > A2007 - 1040 > A2010 - 1040 > Very intriguing, Jim. I ran your code on Access 2000, and got 801 controls, confirming your result. A Google search revealed that the 754 limit is very widely quoted, and even Microsoft's own page repeats this figure: http://support.microsoft.com/kb/208192 But I have personally seen forms with this 754 control limit, however the database was imported from Access 97. So, I still think my theory stands -- but the numbers are correct only for Access 97. Does anybody have an ancient version of Access 97 they can test this on? It is obvious that the control limit was raised in later versions of Access, but the reasons for these particular limits remain mysterious. -Ken -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com